Format or function to drop decimal

  • Thread starter Thread starter Ken King
  • Start date Start date
K

Ken King

I am trying to convert a number with 2 decimal to a 10
digit fixed with implied decimal. So 1.23 would be
0000000123. Is there a custom format or worksheet
function that will do this?

Thanks,
Ken King
(e-mail address removed)
 
Removing the decimal requires you to multiply by 100.
If you can happily lose the original data: put 100 in a blank cell, copy
this, select the range of cells to fix; use Edit|Paste Special Multiply (now
delete the 100). Otherwise you need a new column (=A1*100)

To display leading zeros need custom formatting: 0000000000

best wishes
 
Hi
can't be done with a format but try the formula
=TEXT(A1*100,"0000000000")

Though this is a text value and not a number anymore
 
Back
Top