| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A fixed field format needs fronting zeroes for each cells value.
I need to keep a fixed field width for a file that I am importing into
another program. The other program will only except a certain format. Each field needs to have a specific number of characters and if the values are less than that number we need to right justify and zero fill. Can we have excel recognize the number values and zero fill, on the front end, if there are not enough characters? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading zeroes in ZIP field | Excel Discussion (Misc queries) | |||
| excel .txt to .cvs, lose trailing zeroes in numeric field | Excel Discussion (Misc queries) | |||
| How do I format currency field in Excel 2000 w/o 2 extra zeroes? | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
Threaded Mode
