Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: Digits allowed for a numeric field

    How many digits does Excel allow for a numeric field ? Excel help states the Number Precision has a 15 digit limit, but is Number Precision the maximum number of digits allowed for a numeric number ?

    The issue I am having is I have a number 10,000,004,757,646.84 but Excel keeps rounding the number to .80.

    Is there a way around this ?

  2. #2
    Join Date
    Oct 2003
    Howdy. Maximum is 15. Once it gets to that point, it will round off anything past that. To test it, add three more digits between the 0 and 4 in your example number, and see what happens.

    As far as a work around, if you want to use it as a number, no. If you need it for display purposes, then you could put ' before the number which will retain all the digits, but it will be treated as text, not as a number.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Apr 2004
    Thank you very much Rich. I do need to use the number in a calculation, so at least I'll be able to explain my .04 outage.

Posting Permissions

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