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

    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
    Posts
    1,091
    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!

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

    How to ask a question on forums

  3. #3
    Join Date
    Apr 2004
    Posts
    14
    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
  •