Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 15 digit number limit issue


19 Jul 2010   #1

Windows 7 Home Premium
 
 
Excel 15 digit number limit issue

Try this. Type a 16-digit number in a cell, say:
1234567890123456

Then right click the cell and format this as a number, with no decimal places.
Your number has just become:
1234567890123450 (note the last digit is now a zero).

great stuff. Not. It has effectively corrupted your input (changed your value) without notifying you in any way that you've hit a limit.

My question is - is this known behaviour for Excel 2007?

My System SpecsSystem Spec
.

19 Jul 2010   #2

Windows 7 Ultimate X64 SP1
 
 

Hi skydiver welcome to the forums. It seems this is a known limitation of Excel. See below.

Quote:
Microsoft Excel supports a maximum of 15 significant digits at all times. This limit applies to a value that is calculated by a formula. Because of this limitation, if at any time a formula calculates a value that exceeds 15 digits in length, digits beyond the fifteenth significant digit are changed to zeroes. This may cause the formula to return an incorrect result.
From: Problems vith Statistical Functions and Large Numbers in Excel

Incidentally, I dont know if it helps, but Open Office Calc (which is free by the way ) doesn't have this limitation: http://www.openoffice.org
My System SpecsSystem Spec
19 Jul 2010   #3

Windows 7 Home Premium
 
 

thanks, and thanks.
Seems it was a known limitation, but not to me!
My System SpecsSystem Spec
.


19 Jul 2010   #4

Windows 7 Ultimate X64 SP1
 
 

Quote   Quote: Originally Posted by skydiver123 View Post
thanks, and thanks.
Seems it was a known limitation, but not to me!
Thats alright I didn't know either I had to research it. Then again, I'm an Open Office man.
My System SpecsSystem Spec
Reply

 Excel 15 digit number limit issue




Thread Tools



Similar help and support threads for2: Excel 15 digit number limit issue
Thread Forum
Processors - Limit Number Used by Windows 7 Tutorials
Solved Remote Desktop port number oddity, windows firewall issue? Network & Sharing
Windows 7 home prem serial number issue Windows Updates & Activation
Color dialog prevents third digit in RGB text boxes ? General Discussion
Limit on number of external hard drives? Installation & Setup
Problem Adding 7 Digit QAM Channels Media Center
MSDN limit on number of keys? General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:25 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33