Change format for dollar amount

[smoove]

I need to code a row to change the format of a dollar amount in each cell. In the end the dollar amount has to be exactly 10 characters, the dollar sign and the decimal need to be dropped but not the change.

EXAMPLES:
$1000.22 -converted to- 0000100022
$100.55 -converted to - 0000010055

I can get rid of the "$" and "." but not without the change being removed along with the decimal and I can add a "0" prefix but how do I get the decimal out and leave the change or get excel to calculate how many 0's need to be appended?

I appreciate any help. Thanks in advance!

[Leith Ross]

Hi Smoove,

Back at it - again. Well you're almost there. Select the range you want to change format for. Click Format, Cells..., Number and go down to Custom. Type in ten Zeros: 0000000000

That will do it. A very underutilized function of Excel.

Best,
Leith Ross

[smoove]

Wow!! I thought I was going to need umpteen lines of complex code for that one.
Thank you so much for your help!!!

[smoove]

The change appears to get dropped off. I need to leave the decimal off but keep the change. Any ideas?

[Leith Ross]

You're welcome. Glad I could help.

Leith Ross