How do I display leading zeros so I can export a fixed in Excel?

  • Thread starter World Referee and accountant
  • Start date
W

World Referee and accountant

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.
 
I

Ian Ripsher

"World Referee and accountant" <World Referee and
[email protected]> wrote in message
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.
Click to expand...

Use Format Cells | Number | Custom and enter "000000000#" (without quotes)
in the Type box. The number will then show as padded with enough leading
zeroes to ensure it is displayed as 10 digits.
 
J

JE McGimpsey

If the Amounts are in column A and the account number is in D1, say, one
way:

B1: =D1 & TEXT(A1,"0000000000")

"World Referee and accountant" <World Referee and
 
Top