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 cero 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?
 

Instead of replacing the periods with a comas try this.

Select your data then go to Data/Text to clolumns, select "Fixed Width" then
hit NEXT NEXT, click on "Advance" and for the "Thousands seperator" select
the "." period, FINISH.

HTH
JG

"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 cero 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