Mr. Lawi,

Also try changing the cell format to "Number". I managed to get more than 15 digits in two cells, sum them up and get a result with more than 15 digits.


Me

On 22 August 2011 10:20, Simon Mbuthia <simon.mbuthia@gmail.com> wrote:
http://precisioncalc.com/What_is_xlPrecision.html

HTH


On 22 August 2011 09:57, Mr. Lawi <mail2lawi@gmail.com> wrote:
Hello Skunks,

Anyone with ideas how to circumvent this? I need to do calculations
involving numbers with way more than 15 significant numbers.

LibreOffice Calc has the limit as well.

Its got something to do with IEEE 754 standard, am meant to understand.

Mr. Lawi
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke