30 decimal digits
 

Hi,

A question,

I know that excel is limited to 15 decimal digits.
All following digits are disregarded.

But, and i did not find the answer yet, why is it possible to for,at a
number up to 30 decimal places?

Marketing issue?
Easier colding?



Kind regards,

Willy

30 decimal digits
 

Not quite true. 15 *significant* figures is the precision. e.g.
0.000000000000000234234234234234 displays correctly with 30 decimal
places

On Mar 11, 6:16 pm, WIlly Haagen wrote:
Hi,

A question,

I know that excel is limited to 15 decimal digits.
All following digits are disregarded.

But, and i did not find the answer yet, why is it possible to for,at a
number up to 30 decimal places?

Marketing issue?
Easier colding?

Kind regards,

Willy

30 decimal digits
 

And if the concept of significant digits is unfamiliar to you: think of the
number being displayed in scientific notation (e.g. 1.23456E-6). Excel can
store the bit in front of E to only 15 digits of precision.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"WIlly Haagen" wrote in message
...
Hi,

A question,

I know that excel is limited to 15 decimal digits.
All following digits are disregarded.

But, and i did not find the answer yet, why is it possible to for,at a
number up to 30 decimal places?

Marketing issue?
Easier colding?



Kind regards,

Willy