| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I display leading zeros so I can export a fixed in Excel?
I need to export a file from Excel that has a fixed length of 18 digits, the
first 8 digits are account numbers the last 10 digits are the amounts. I need the amount field to have a fixed length of 10 digits. I know I can use the CONCATENATE command to add the account number to the amount but the amount field doesn't have a fixed field length. The file is then exported and is used to import data into some other application. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display a pix from a URL in a Excel cell | Excel Discussion (Misc queries) | |||
| Can I export Excel data into another software? | Excel Discussion (Misc queries) | |||
| Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
| How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. | Excel Discussion (Misc queries) | |||
Threaded Mode
