Conversion to number format

Copper Contributor
 

Hola, estoy trabajando con una base de datos pero necesito que ciertos campos me queden en formato numero, pero en ningún momento me da la opción de convertirlos y así yo lo haga manualmente no ocurre nada. Los datos me siguen quedando en la parte izquierda de la celda. Ayuda por favor

2 Replies

@jfdiaz 

Select the column with Numbers recognized as Text entries then go to Data Tab --> Text to Columns --> and click on Finish in the first step itself. This will convert Numbers in that column as real Numbers.

If I can recommend you add a file (without sensitive data) and describe your problem in relation to this file.
This is usually the quickest way to get a suggested solution in this forum.
Otherwise the helper always has to guess what it could be.
After a certain amount of time, guessing is not the best thing you want to do in this forum :)

Thank you for taking the time to read my recommendation.

Nikolino
I know I don't know anything (Socrates)