| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Converting number to text | Excel Discussion (Misc queries) | |||
| converting text to number | Excel Discussion (Misc queries) | |||
| converting a number to English text ( not to Baht) is needed | Excel Worksheet Functions | |||
| converting an arabic number into a spellout text | Excel Worksheet Functions | |||
Hybrid Mode
