Format or function to drop decimal

[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)

 

[Bernard Liengme]

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

 

[Frank Kabel]

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