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
skydiver123

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
severedsolo

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
skydiver123

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
severedsolo

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
08 Sep 2015   #5
POlicarpo

Windows 7
 
 

Hi

I had problems with the 15 character limit for the execel but I could solve using the following tools:
xlPrecision
I paid $ 13 for the license and it worked fine, but it was hard to find ...
So I'm posting this solution to help those who have the same problem!
My System SpecsSystem Spec
Reply

 Excel 15 digit number limit issue




Thread Tools




Similar help and support threads
Thread Forum
How can I limit the number of active local sessions
I wasn't really sure which forum to post this under, but my concern is based on the limited resources available to PCs so I put it here; anyway .... I'm interning/working at a college, and right now we're talking about the issue of students walking away from the PCs without logging off. While...
Performance & Maintenance
Constant (the digit 1), along with beep, running on my computer.
I have a toshiba pavillion, 3, using a external monitor and wired keyboard. It has started filling in every thing that requires an input, with the number 1. It starts on boot. I can safe boot, but most of time it starts again once i have to fill in info, just runs the number 1 and beeps...
General Discussion
Processors - Limit Number Used by Windows 7
How to Set the Number of Processors or Cores to be Used by Windows 7 If you have a multiple core processor (CPU) or multiple processors, then this will show you how to limit the number of processors to be used by Windows 7, or to make sure that you are using all processors. This can be handy...
Tutorials
Limit on number of external hard drives?
Does Windows 7 have a limit on how many USB external hard drives it will use? We have 5 WD My Book 1TB drives; 4 of them are recognized and work just fine with Windows 7 Home Premium 64 (which we recently did a clean install of to replace Vista Home Premium 64), but the 5th one doesn't show up...
Installation & Setup
MSDN limit on number of keys?
Hi guys whats up. So in MSDN i am trying to DL windows 7 but i just have a question. You guys (MSDN subscribers ) have any idea on how many keys i can generate? because i accidentlly clicked the generate key twice and it gave me two keys :p. Thats not a problem is it? And also can these keys be...
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 14:42.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App