formating the number from 12345.1 to 12345.001
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.
|