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 |
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 |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com