auto rounding for quadrillion numerals
I am trying to enter a number that is in the quadrillion range, nowever,
Excel automatically rounds it to the zero. For example, if I type in the
following numeric 123,456,789,123,456,789,123,456,789 Excel gives me
123,456,789,123,456,000,000,000,000. I have the cell formatted as Number,
with no decimals and changing Excel's precision settings with no luck.
I am seeing this in Excel 2000, 2003, and 2007.
Any ideas would be welcome.
Thanks!
|