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

Try formatcustom format0000000000 (or as many as you want)

That will eliminate the decimal portion of the number, not what the original
poster requires.


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

"Don Guillett" wrote in message
...
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

Thanks Chip.

"Chip Pearson" wrote in message
...
Try formatcustom format0000000000 (or as many as you want)

That will eliminate the decimal portion of the number, not what the
original
poster requires.


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

"Don Guillett" wrote in message
...
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