Rounds down decimal numbers

Jul 24, 2014 at 4:28 PM
Hi!
First of all, this is a great lib!
But sadly I have a problem, when I try to save high precision numbers in a worksheet, (which are stored as decimals) thay got rounded down to 15 decimals, but originally I had 18.
How can I solve this problem?
Jul 25, 2014 at 5:27 AM
It's excel limit.

Find ref. here:
http://office.microsoft.com/en-in/excel-help/excel-specifications-and-limits-HP010342495.aspx#BMcalculation

If your data are not use for calculation and only for display purpose, better you format it as TEXT.