15 digit restriction

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
I'm not aware of a 15 digit restriction.? Is it because it is displayed as scientific notation? If so just format the cell as number to get back to the full written number.

Also not sure what mat operations is ?
 
Upvote 0
From help file:

"The General number format
In cells that have the default General number format, Excel displays numbers as integers (789), decimal fractions (7.89), or scientific notation (7.89E+08) if the number is longer than the width of the cell. The General format displays up to 11 digits, including a decimal point and characters such as "E" and "+." To use numbers with more than 11 digits, you can apply a built-in scientific number format (exponential notation) or a custom number format.

15-digit limit
Regardless of the number of digits displayed, Excel stores numbers with up to 15 digits of precision. If a number contains more than 15 significant digits, Excel converts the extra digits to zeros (0)."
 
Upvote 0
Can you be more specific about which operations, number of decimal places and how willing you are to try unique approaches?

In the past in other languages, I have programmed the three basic functions (not division) for numbers of unlimited length as long as they were text. My code then did what any 2nd grader would do, digit by digit manipulation and store the result as text. Very convoluted to do, but it worked.

Another solution would be to act on each number in part. Store the numbers in chunks and act on simliar chunks. This works for addition and subtraction but not multiplication or division.
 
Upvote 0
Googleelgoog,

Can you post some sample numbers you would want to add and subtract? How many digits do you need? Are the numbers integers or do they have decimal points? Can the numbers be stored as text in the spreadsheet?
 
Upvote 0
Seti said:
Googleelgoog,

Can you post some sample numbers you would want to add and subtract?
How many digits do you need?

Could be any number which has 16 digit.

Seti said:
Are the numbers integers or do they have decimal points?
They are integer.

Seti said:
Can the numbers be stored as text in the spreadsheet?

Yes.


Thank in advance.
 
Upvote 0
Okay, as an example of the limitation I mentioned above...column B shows the numbers that were entered in column A. Notice how XL slashes the numbers off after 15 digits. This will apply to integer, and decimal values.
Book8
ABCD
1NumberText
2123,456,789,012,345123456789012345
31,234,567,890,123,4501234567890123456
412,345,678,901,234,50012345678901234567
5123,456,789,012,345,000123456789012345678
61,234,567,890,123,450,0001234567890123456789
712,345,678,901,234,500,00012345678901234567890
8123,456,789,012,345,000,000123456789012345678901
91,234,567,890,123,450,000,0001234567890123456789012
1012,345,678,901,234,500,000,00012345678901234567890123
11123,456,789,012,345,000,000,000123456789012345678901234
121,234,567,890,123,450,000,000,0001234567890123456789012345
1312,345,678,901,234,500,000,000,00012345678901234567890123456
14123,456,789,012,345,000,000,000,000123456789012345678901234567
151,234,567,890,123,450,000,000,000,0001234567890123456789012345678
1612,345,678,901,234,500,000,000,000,00012345678901234567890123456789
1713,717,421,001,371,700,000,000,000,000=sum(B2:B16)
Sheet1
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top