15 digit restriction

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
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
Joined
May 15, 2003
Messages
8,638
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)."
 

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916

ADVERTISEMENT

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.
 

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
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?
 

googleelgoog

New Member
Joined
Mar 2, 2004
Messages
9
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.
 

TommyGun

MrExcel MVP
Joined
Dec 9, 2002
Messages
4,202
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,573
Members
413,996
Latest member
mabelO

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
Top