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:

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 10 Pro x64

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

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:
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 10 Pro x64

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

Windows 7


I had problems with the 15 character limit for the execel but I could solve using the following tools:
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

 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...
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 21:57.
Twitter Facebook Google+