| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a right justified zero filled field to a prn file
I need to save the excel file to a PRN file. One of the fields, according to
the spec, is a numeric filed (check amount), right aligned and zero filled for total 10 characters in length. (0000010050 for $100.50) Would you have an advice on the formatting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dollar sign left justified - data right justified - large space | Excel Discussion (Misc queries) | |||
| How do I save a 689 character fixed field/record format file | Excel Discussion (Misc queries) | |||
| by default text is left justified, numbers are right justified - a specific reason for this? | Excel Discussion (Misc queries) | |||
| rows top-justified & bottom-justified in same sheet looks bad | Excel Worksheet Functions | |||
| Microsoft Excell does not format the data numbers right justified. | Excel Discussion (Misc queries) | |||
Threaded Mode
