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

--
mell
-----------------------------------------------------------------------
melle's Profile: http://www.excelforum.com/member.php...fo&userid=2698
View this thread: http://www.excelforum.com/showthread.php?threadid=46709

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

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=46709