LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto rounding of large numbers GKW in GA Excel Discussion (Misc queries) 2 April 21st 08 06:17 PM
Relating numerals as text BilyumQ Excel Discussion (Misc queries) 1 April 16th 07 04:40 AM
Decimal Places - Settings for Auto Rounding Up/Down Holmes, Maria Excel Worksheet Functions 2 February 10th 06 05:52 PM
Numerals changing Crocketty Excel Discussion (Misc queries) 10 May 19th 05 03:30 AM
Function for Roman Numerals Gary's Student Excel Worksheet Functions 6 April 27th 05 08:25 PM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"