Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jul 2006
    Location
    Colleyville, Texas, USA
    Posts
    45
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Newly Entered Number is Changed when Moving from that Cell

    This was tried in both versions 2003 and 2007 each on different computers (individual copies of software on c-drive, with the same result.

    A 19-digit utility account number is entered into a cell. When moving out of that cell, the last 4 digits are changed. The number format is Number, although we've tried other formats resulting in the last 4 digits are replaced with zeros.

    We inserted a new column far away from this particular column, with the same problem. We entered the 19-digit utility account number on a new spreadsheet, formatted as Number, with the same result.

    This occurs with all of the various account numbers. One of the numbers is: 8000216585105189703 ... becomes 8000216585105180000

    We replaced the "8" at the beginning of the number with a "4," with the same result.

    However ... if a hyphen is included anywhere in the 19-digit number, the number remains exactly as typed: 80-00216585105189703 -or- 800021658-5105189703 -or- 800021658510518970-3

    Is there an explanation for this?

    Thanks ... Diane

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Microsoft Excel supports a maximum of 15 significant digits.
    Take a look here .....
    Excel 15 digit number limit issue

    You could precede your number with an apostrophe and it will look like a number
    '8000216585105189703

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Utility acc codes

    Hi
    Adding hypens
    The addition of a hyphen creates a mix of alphabetic and numeric characters. ie. the entry is no longer a number so no arithmetic.

    This would be analogous to a phone number (+64) 09-1234-5678.
    Unlikely you would ever find the average of the phone numbers !!


    Cheers
    G

  4. The Following User Says Thank You to geofrichardson For This Useful Post:

    dbrequest (2011-04-04)

  5. #4
    Lounger
    Join Date
    Jul 2006
    Location
    Colleyville, Texas, USA
    Posts
    45
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you ... that explains it. I appreciate the suggestions offered.

    Diane

Posting Permissions

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