Replace works not in recorded VBA

[rpinxt]

Hi all,
I recorde a macro to replace my commas in amount with dots.

Please Login or Register  to view this content.

Works manually while recording it ok.
But when I run the recorded macro it will not replace anything....

[davesexcel]

Your code works for me, here is is cleaned up a bit.

Please Login or Register  to view this content.

If you are trying to change the commas in an actual number, you would have to format the cells as text first.

[rpinxt]

Thanks but it does nothing for me.....
Also when I first change the format...it still keeps showing "," and not "."

[rpinxt]

Let me sent a sample which does not work for me.
My Office settings are Dutch so decimals separator is ",".

[bart hoekstra]

Hi

Run it in Xcel2007. It works fine here.

bart

[TMS]

The data in column A in your sample is numeric. With my regional settings, the decimal part is separated by a full stop (dot). In yours, it may be a comma (,).

If I do a global replace (using your code) and change full stop to comma, it works but the data becomes text where there is a decimal part. I can then reverse the process and it becomes numeric again.

Nothing wrong with the code as it stands.


Regards, TMS