| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert decimal commas to decimal points?
I have mulitple cells with data in the format 153,95 and I need to convert
these to 153.95. Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I convert decimal commas to decimal points?
Ctrl + H find what , replace with .
Note that if you open a workbook with this formatting or send it to someone it will be converted without any input -- Regards, Peo Sjoblom "Peteylepieu" wrote in message ... I have mulitple cells with data in the format 153,95 and I need to convert these to 153.95. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combobox changes the decimal commas to dots - How to prevent it? | Excel Discussion (Misc queries) | |||
| decimal points in my spreadsheet | Excel Discussion (Misc queries) | |||
| Formatting Decimal points | Excel Discussion (Misc queries) | |||
| Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
| Decimal Points | Excel Worksheet Functions | |||
Linear Mode
