Re: excel generated polynomial equation is wrong

Hi. I think the 30 digits is to allow one to see all the digits using the
basic Number format.
If you format a cell with the Number format, and use the scroll button, you
are limited to 30 digits. I think this is what the article was referring
to.
For example, if you enter the following number:
=123456789012345*(1E-30)
and use the number format out to 30 digits, you will be able to see all the
digits. (Under Number format).
So again, the article seems to suggest using the Number Format, and the
Number format seems limited to 30 Digits. (as seen from the scroll buttons).
What's funny is that the toolbar button "Increase Decimal" can override this
limitation.

--
HTH :>)
Dana DeLouis
Windows XP & Office 2003


"MartinW" <mtmw@xxxxxxxxxxxxxxx> wrote in message
news:OryOqVc4GHA.3452@xxxxxxxxxxxxxxxxxxxxxxx
Hi Dana,

The article you linked to says to set your number to 30 decimal
places yet Excel will only display precision to 15 significant digits.

Is this a situation where Excel will calculate to a higher precision
but only display to the limits?
Is it sort of like a cell only displaying 1024 characters even though
it will accept and use a greater amount of data?
Also, if that is the case, what is the limit of decimals.

Thanks
Martin



.