| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change dots to commas!!
Hey
I have imported some US financial data and would need to transform the dots to commas to be able to do calculations, i.e. 1.45667 to 1,45667 How do I do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change dots to commas!!
Which version of Excel are you running?
2002 and newer allows you to change the dots and commas at ToolsOptionsInternational. Alternative......change the settings in Control PanelRegional and Language Settings Gord Dibben MS Excel MVP On Fri, 17 Nov 2006 16:16:01 -0800, Andreas wrote: Hey I have imported some US financial data and would need to transform the dots to commas to be able to do calculations, i.e. 1.45667 to 1,45667 How do I do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
| Find function | Excel Worksheet Functions | |||
| Find function | Excel Worksheet Functions | |||
Linear Mode
