Format decimal values

  • Thread starter Thread starter jzimmer
  • Start date Start date
J

jzimmer

We need to format values such as 7.5, 8.0, 1.92, 2.78 etc in the forma
of 0750, 0800, 0192, 0278. I have tried 0000 as a custom format bu
not giving me the desired results
 
jzimmer > said:
We need to format values such as 7.5, 8.0, 1.92, 2.78 etc in the format
of 0750, 0800, 0192, 0278. I have tried 0000 as a custom format but
not giving me the desired results.
Click to expand...

You need to multiply your numbers by 100 and then format as 0000 .
You can multiply using a formula such as =A1*100 .
Alternatively, put 100 in a spare cell and copy it. Select all your numbers
and use
Edit > Paste Special > Multiply > OK .
 
Back
Top