Thread: How can I convert decimal commas to decimal points?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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 With QuoteReply With Quote