ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   converting text to number (https://www.excelbanter.com/excel-worksheet-functions/122018-converting-text-number.html)

Julio

converting text to number
 
I imported a text to excel but a number that should be 24,33 was converted as
2433; It´s possible to convert directly with decimal format?

John Bundy

converting text to number
 
How did you import the data? If you did it with the "import external data"
option then you can set how it will display in the options

-John

"Julio" wrote:

I imported a text to excel but a number that should be 24,33 was converted as
2433; It´s possible to convert directly with decimal format?



All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com