Replace "." to ","
 

Hi, can you help me?
I need replace dot (.) to comma (,) in worksheet cells.
The number format is "123 456,00" in my international settings.
Another application export numbers as "123.1234" format, but Excel knows the
number as "123,1234" format. The cells a
34.2444 0.5687 97.7290 0.8474
34.2677 0.5689 97.7180 0.8067 ...

The Selection.Replace What:=".", Replacement:="," ... command replace these
cells as:
342 444 0,5687 977 290 0,8474
342 677 0,5689 977 180 0,8067
but I need as:
34,2444 0,5687 97,7290 0,8474
34,2677 0,5689 97,7180 0,8067

Thank you your time

Replace "." to ","
 

try again but first change your international settings to allow 4
decimals using the "customize" button on the regional and language
options in control panel.


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=471856

Replace "." to ","
 

I thank your advice, but it can't help me.

I tried to format the cells, like as "@" format and other custom format, but
it doesn't work.

If I replace "." to "," in these cells (34.2444 0.5687 97.1233 ...) in
Excel with the Find&Replace dialog, it works properly. I record this commands
and I play back it in VBA, the command doesn't work.
If the cell's value is less then ~ 0.9999 or the decimals is 2 the replaced
value is good but its formatted as text. If the cell's value greater than
1.0000, the ","/"." vanish from the replaced value (1.0000 -- 10 000)