Try formatcustom format0000000000 (or as many as you want)

"Clay" wrote in message
...
Hello,

I am not too good with Excel formulas, hopefully one of
you can help! I have a column currency amounts as shown
below.

8631.36
40729.54
47749.70
189.12

I need to write a formula that will convert this to a 9
digit, non-decimal number. So, after the formula, I need
the above to look as shown below:

000863136
004072954
004774970
000018912

Than You in advance!
Clay