Forum Discussion
jfdiaz
Sep 27, 2020Copper Contributor
Conversion to number format
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
- NikolinoDEPlatinum ContributorIf 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) - Subodh_Tiwari_sktneerSilver Contributor
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.