googleelgoog
New Member
- Joined
- Mar 2, 2004
- Messages
- 9
Hi all,
How can I use more than 15 digits in Mat. operations?
Thanks in advance.
How can I use more than 15 digits in Mat. operations?
Thanks in advance.
This works for addition and subtraction but not multiplication or division
Seti said:Googleelgoog,
Can you post some sample numbers you would want to add and subtract?
How many digits do you need?
They are integer.Seti said:Are the numbers integers or do they have decimal points?
Seti said:Can the numbers be stored as text in the spreadsheet?
Book8 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Number | Text | ||||
2 | 123,456,789,012,345 | 123456789012345 | ||||
3 | 1,234,567,890,123,450 | 1234567890123456 | ||||
4 | 12,345,678,901,234,500 | 12345678901234567 | ||||
5 | 123,456,789,012,345,000 | 123456789012345678 | ||||
6 | 1,234,567,890,123,450,000 | 1234567890123456789 | ||||
7 | 12,345,678,901,234,500,000 | 12345678901234567890 | ||||
8 | 123,456,789,012,345,000,000 | 123456789012345678901 | ||||
9 | 1,234,567,890,123,450,000,000 | 1234567890123456789012 | ||||
10 | 12,345,678,901,234,500,000,000 | 12345678901234567890123 | ||||
11 | 123,456,789,012,345,000,000,000 | 123456789012345678901234 | ||||
12 | 1,234,567,890,123,450,000,000,000 | 1234567890123456789012345 | ||||
13 | 12,345,678,901,234,500,000,000,000 | 12345678901234567890123456 | ||||
14 | 123,456,789,012,345,000,000,000,000 | 123456789012345678901234567 | ||||
15 | 1,234,567,890,123,450,000,000,000,000 | 1234567890123456789012345678 | ||||
16 | 12,345,678,901,234,500,000,000,000,000 | 12345678901234567890123456789 | ||||
17 | 13,717,421,001,371,700,000,000,000,000 | =sum(B2:B16) | ||||
Sheet1 |