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