Need to convert #,# into #,#00 or #,## into #,##0?
 

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

Need to convert #,# into #,#00 or #,## into #,##0?
 

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