I need to format a column of numbers (dollars and cents) from an outside
company to ftp it to a financial website and it must be in the following
format:

Leading zeros to make the cell 10 characters long and can have no decimal
point.

I did a custom format which is fine until I get to a dollar amount that does
not have cents. Example:

Original:
100.25
1.00
550.00
Custom format
0000010025
0000000001
0000000550

Does anyone have any ideas on how I can accomplish this?
Thanks!