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 7 Ultimate X64 SP1

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 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

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 Search this Thread
Search this Thread:

Advanced Search

Similar help and support threads
Thread Forum
Dual Monitor identity number issue
I just got a new 2nd monitor (Samsung S24D390HL). My primary was (ASUS VS248H-P). I want to switch their roles. I understand how to go to display settings and drag them around, or how to click on my new monitor and list it as the primary display. My issue is I want to use the Samsung (listed...
Graphic Cards
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...
Windows 7 home prem serial number issue
Hi I hope you can help with a recent issue thats shown itself. I bought a used Acer Aspire 5542 laptop months ago running Win 7 home prem with all the latest updates and everything running fine. A few days ago a message popped up telling me the serial number was invalid although there is the...
Windows Updates & Activation
Color dialog prevents third digit in RGB text boxes ?
Hello, Running windows 7 Pro 64bit. GUI - classic theme, 108 dpi. I was allways using some solid custom color for my background. So I tried to select it using Personalize.... custom color dialog. It's standard color dialog present on all windows versions. One of the ways to enter exact color...
General Discussion
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 04:39.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App