Clay,

You can use a formula like

=TEXT(A1*100,"000000000")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"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