Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ACCOUNT NUMBERS (2002)

    What is the best way to enter account numbers in a "financial" spreadsheet?
    Some are very long (20+ digits), some are alphanumeric, and some have leading zeros.
    I was using a custom format of "00000000000000000000", but it seems that after about 16 digits, all I get are zeros...

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ACCOUNT NUMBERS (2002)

    You need to enter them as text to display more than 15 digits. Excel only displays 15 significant digits.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCOUNT NUMBERS (2002)

    What's the best way to enter them as text? Use the apostrophe?

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ACCOUNT NUMBERS (2002)

    You can either precede it with an apostrophe or format the cell as text.

    Dick Kusleika describes a similar process with credit card numbers

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ACCOUNT NUMBERS (2002)

    To add to what Tony said, if you format the cells as Text, you must do the format BEFORE you enter the value into the cell. Once the value is stored as a number, Excel will not convert it to text when you format the cell. There are ways to force the conversion if you already have a lot entered, but you can't get the lost digits back for any that are over 15 digits.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •