Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto rounding of large numbers | Excel Discussion (Misc queries) | |||
Relating numerals as text | Excel Discussion (Misc queries) | |||
Decimal Places - Settings for Auto Rounding Up/Down | Excel Worksheet Functions | |||
Numerals changing | Excel Discussion (Misc queries) | |||
Function for Roman Numerals | Excel Worksheet Functions |