| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dollars to text without loosing zeros from decimal places | Excel Worksheet Functions | |||
| Leading decimal and zeros in formating numbers | Excel Discussion (Misc queries) | |||
| Insert Decimal Places and Clear Zeros | Excel Discussion (Misc queries) | |||
| Leading Zeros and decimal points | Excel Worksheet Functions | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Linear Mode
