| 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! |
| 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) | |||
Threaded Mode
