Results 1 to 7 of 7
  1. #1
    CorpTrainer
    Guest

    Significant digit limitation (Excel all versions)

    OK I am trying to enter 16 digit credit card numbers and with the 15 digit significant digit limitation EXCEL changes the last digit to a zero. I can work around by changing the format to TEXT and then entering the account number.

    Anyone have a better work around? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Significant digit limitation (Excel all versions)

    15 is all you can get with numbers. You can do the text format as you enter the credit card number by entering a leading single quote before the number. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

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

    Re: Significant digit limitation (Excel all versions)

    Nope, entering it as text is the best solution.
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Mar 2004
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Significant digit limitation (Excel all versions)

    I would just format the entire column or row to text before entering the data. This would be quick, easy, and foolproof.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Significant digit limitation (Excel all versions)

    Everyone else is corrrect, but I do have one lunatic idea for your amusement. Most credit card numbers are broken up/spaced on the card. If you need to you can enter each section as a number in it's own column, and then use the text function to display the combined card number, like this:

    Cell: A3 B3 C3 D3
    Contents: 1234 5678 9012 3456

    =TEXT(A3,"0000-")&TEXT(B3,"0000-")&TEXT(C3,"0000-")&TEXT(D3,"0000") will return 1234-5678-9012-3456
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Significant digit limitation (Excel all versions)

    With this approach, if a segment begins with a zero, the result as displayed in the entry cell will drop the leading zero, unless you apply a custom number format to retain it, specifically "0000" (without the quotes).

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Significant digit limitation (Excel all versions)

    Good point; I was forcing leading zeroes with =TEXT(A3,"0000") in the concatenation, but forgot to suggest formatting the number cells that way. Hey, it was a pie-in-the-sky idea anyway!
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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