View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ffnapa
 
Posts: n/a
Default 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