decimal places and leading zeros
 

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!

decimal places and leading zeros
 

So you have
0000000001
but you want
0000000100

Assuming that to be the case then you probably want to create a new column
which multiplies the value by 100 (1 becomes 100, 100.25 becomes 10025 ...).
You can then custom format the new column to
0000000000
--
HTH...

Jim Thomlinson


"Vic" wrote:


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!

decimal places and leading zeros
 

Perfect! Thanks very much.

"Jim Thomlinson" wrote:

So you have
0000000001
but you want
0000000100

Assuming that to be the case then you probably want to create a new column
which multiplies the value by 100 (1 becomes 100, 100.25 becomes 10025 ...).
You can then custom format the new column to
0000000000
--
HTH...

Jim Thomlinson


"Vic" wrote:


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!