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. |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
If the Amounts are in column A and the account number is in D1, say, one
way: B1: =D1 & TEXT(A1,"0000000000") In article , "World Referee and accountant" <World Referee and wrote: 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. |
Reply |
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) |