EXCEL DIGITS being changed to ZEROS!!! HELP
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: EXCEL DIGITS being changed to ZEROS!!! HELP

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    When I enter a number with 16 + didits in excel, it converts the 16th and higher digits to ZEROS! HELP!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 10:37, RobertYoung wrote:
    When I enter a number with 16 + didits in excel, it converts the 16th and higher digits to ZEROS! HELP!
    That's because Excel only supports precision to 15 digits. See the Excel Help Index topic for "limits in Microsoft Excel" and consult the "Worksheet and workbook specifications".

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there anything I can do, so that I can create a 16 digit #?

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Robert:
    This question has also come up earlier ... and there was a pretty good discussion on this. I would suggest looking at the following thread also:

    http://www.mrexcel.com/board/viewtop...c=3306&forum=2

    Regards!

  5. #5
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nope, that's why it's called a limit.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 10:48, RobertYoung wrote:
    Is there anything I can do, so that I can create a 16 digit #?
    Enter it as a text value (e.g., "1234567890123456"). If you're trying to enter an account or credit card number you should enter it as text anyway because you're not gonna perform arithmetic operations on 'em!!

    Just format these cells as Text prior to data entry.

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks all...looks like I'm limited to 15.

    RY

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com