You sshould have just relaced all the "," with "". This would make it a
number that Excel can recognise. Then use format it to get comma's.

"Ffnapa" wrote:

I am copying tables with numbers using "." instead of "," separators (Ex.
34.677.970) . When replacing "." for "," I got this 34,677,97 ..the Zero is
gone and Excel does not treat this as a number anymore. How can preserve
those original missing Zeros or how can those missing zeros be added so the
values are still numbers and not text.
Thanks in advance