Maximum number in Calc.

Nuribat · Newbie Joined: 16 Oct 2008 Posts: 3

Help me please.

I am using OOo Calc 3.0. on Windows XP SP3
When I type 999999999999999 in a cell, it displays 1000000000000000.
How to solve this ?
And, is there maximum numeric value can be entry in OOo Calc ?

Thank you.

Best regards,

Nuribat

keme · Posted: Thu Oct 16, 2008 9:09 am Post subject:

There are two factors to consider here: precision and magnitude.

Calc stores numbers with a precision of approximately 14 decimal digits. That means there will be rounding errors with numbers containing more than 14 significant digits. (That's the reason for your issue. Solve it by using a tool that can calculate with higher precision.)

The highest numerical magnitude that Calc can handle is around 1,8*10^308 (that's 18 followed by 307 zeroes).

Nuribat · Newbie Joined: 16 Oct 2008 Posts: 3

Thank you, Keme.