Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How many digit numbers can Microsoft Excel handle?

How much maximum digit number can Microsoft Excel work with

user-image
Question added by Muhammad Idris
Date Posted: 2017/11/04
SUFAID HUSSAIN
by SUFAID HUSSAIN , Senior Accountant , Binkhamis International Trading Company

Default number format in Excel is General therefore you can display up to 11 digits in a cell.

15 digits per cell and replaces all remaining digits with 0

Deleted user
by Deleted user

MS Excel can handle 15 digits.

Ubaid Zahoor
by Ubaid Zahoor , Backend Developer , Tremau

In cells of excel that are formatted as text, you can type up to 32,767 characters, of which Excel displays up to 1,024 characters on the worksheet  you cannot create a custom number format that stores more than 15 digits.

معن ابراهيم
by معن ابراهيم , امين مستودع , مؤسسة الصمادي الاكترونيات

 

 

If I type in a 16 digit number (format: number, no decimals) it changes the number on me. Example: 1234567812345678 changes the view to 1234567812345670.

 

If I type it in as a general format it changes the numbers above so it displays 1.23457E+15 but if you click on the cell, the display shows the last digit as a 0 instead of an 8 once again.

 

I opened the file on a different computer and same issue now with it. I have changed the auto correction and auto formatting all to no avail. Help!

More Questions Like This