| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting numbers
You are welcome! Thanks for the feedback!
Stefi Aruna ezt *rta: Hi, It works! thanks a lot. Regards, Aruna "Stefi" wrote: I suppose that your import is of text format. This formula converts strings to numbers if your system decimal separator is ".": =SUBSTITUTE(A1,",","") Regards, Stefi Aruna ezt *rta: Hi Stefi, Thanks for your reply. It was correct but my question is different. I make data import from another system into excel. Ex. of import: 20,985.56 254.04 3,762.29 1,026.68 116.29 Is there any function that can transform them into: 20985.56 254.04 3762.29 1026.68 116.29 Thanks. "Stefi" wrote: This is a matter of regional settings. Either change your Windows system settings or for one workbook you can override them (in Excel2003) by ToolsOptionsInternational tab (I'm translating back to English, the name may be different, it's located between Color and Save tabs), uncheck system settings and enter desired characters in decimal separator and thousands separator field. Regards, Stefi Aruna ezt *rta: Change format of numbers. For example, from 20.566,70 to 20,566.70 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting numbers as 1st 2nd | Excel Worksheet Functions | |||
| Formatting Numbers | Excel Discussion (Misc queries) | |||
| Formatting numbers | Excel Discussion (Misc queries) | |||
| formatting numbers | Excel Discussion (Misc queries) | |||
| formatting numbers | Excel Worksheet Functions | |||
Hybrid Mode
