Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a limit in Excel 2003 to the number of digits a number can contain?

    When I enter the number 4912150001548892, Excel is changing it to 4912150001548890. It does not seem to matter the format of the cell, General or Number. Other numbers of the same length seem to enter with no issues, 4912150001748877.

    Any ideas??


    Thanks for ANY help.
    Richard

  2. #2
    Star Lounger
    Join Date
    Dec 2009
    Location
    Mexico City, D.F., Mexico
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Numbers have a limited precision of about 16 digits (sometimes 15, sometimes 16 depending on the number), which is usually more than enough for mathematical calculation. If you need to store this number exactly and don't plan to do math on it, type a single quote before it. It will be displayed without the single quote and treated as a text.
    This eco-post is made of recycled electrons

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Other than for Government deficit forecasters, I don't know any practical uses for more than 15 digits.

    As can be seen below, more than 30 digits from some calculations can be displayed as numeric values.

    Note the formula in cell A64.

    [attachment=89449:More than 16 numbers.jpg]


    For anyone interested in the names of large numbers(million, billion, trillion, etc.).
    The attached PDF file has the names by American, European, Greek and by SI prefix.

    [attachment=89460:Names of large numbers.pdf]
    Attached Images Attached Images
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the relpies.

    I did find in the Help that numbers are store to 15 digits.

    I have converted the column for this value to text and will be storing the number as such.


    Thanks again for your help.
    Richard

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    As can be seen below, more than 30 digits from some calculations can be displayed as numeric values.
    But after the first 15 digits the rest are always zeroes....

    Steve

Posting Permissions

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