Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |