In Excel 2003, using Windows XP, if I input a number over 15 digits long, it always truncates that number.
i.e. if I enter "95465321597895592158" as a number, Excel only enters the following, "95465321597895500000".
However, I need to do some accurate calculations with numbers in excess of 15 digits...
For example: 526632145963546843 - 526632145962315821
When inputting this into Excel, it yields 1230976
However, the correct answer to this problem is easily done by hand to yield 1231022.
So my question is, how can I get Excel to accurately deal with these numbers that are over 15 digits? Is it even possible?
I know it may seem absurd to be dealing with such large numbers, but anybody that can help would be greatly appreciated!
Thanks,
yachadhoo
2006-10-09
19:23:33
·
2 answers
·
asked by
yachadhoo
6