1.25 to 1,25

  • Thread starter Thread starter melle
  • Start date Start date
M

melle

:eek: Hey,

I am working in an excel sheet. In a row are 100's of values.

I want to change . to ,

So, I have for example the number 1.25 and I want to change it int
1,25.



Manually is too much work.

Thank's in advance
 
Try Find/Replace:

Find what: .
Replace with: ,

Replace All

Note that this makes the entries Text, and not available fo
calculations. Is this what you want? If you are looking to change th
decimal to a comma for regional compliance, you need to adjust you
settings in Windows>Settings>Regional and Language>Regional Options an
pick the country you want to match. Click Apply.

Good Luck

Bruc
 
Back
Top