# 15 digit restriction

##### New Member
Hi all,
How can I use more than 15 digits in Mat. operations?

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### GorD

##### Well-known Member
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 ?

#### fairwinds

##### MrExcel MVP
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)."

#### GorD

##### Well-known Member
So it does, I didn't know that

#### Seti

##### Well-known Member
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.

##### New Member
This works for addition and subtraction but not multiplication or division

Ok... That's what I want (just add & sub).

Could you please give me more clue?

#### TommyGun

##### MrExcel MVP
This is a limit of the CPU not XL...

15 Digit Limitation

#### Seti

##### Well-known Member

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?

##### New Member
Seti said:

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.

#### TommyGun

##### MrExcel MVP
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

Replies
2
Views
320
Replies
5
Views
571
Replies
7
Views
291
Replies
9
Views
209
Replies
5
Views
486

1,181,607
Messages
5,930,874
Members
436,764
Latest member

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

### Which adblocker are you using?

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

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