View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mmarch mmarch is offline
external usenet poster
 
Posts: 1
Default 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!