View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default formating the number from 12345.1 to 12345.001

Be advised, a formatting solution is only an "appearance"
solution.............the numbers will still be 12345.1 and 12345678.1 if you
have to do any math with them............

Vaya con Dios,
Chuck, CABGx3




"sr25" wrote:

Thanks JE it worked!!!!

"JE McGimpsey" wrote:

One way:

Format/Cells/Number/Custom 0.\0\00


In article ,
"sr25" wrote:

I have the column with the data 1234.1 or 12345678.1 and I would like to
change them adding 00 zeros right after the period and the result should be
1234.001 Any help is appreciated.