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
|