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