How can I work with more than 15 numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a little problem. I don't know how to work with numbers greater than
15 digits. If someone can help me, please don't hesitate. thanks!
 
Enter them in cells preformatted as Text or with a leading apostrophe
(').

If you're just entering credit card numbers, or suchlike, you generally
don't need to do math, so this should suffice.

XL's limited to 15 decimal digits of precision, so to work with numbers
with more digits than that will require you to use string functions to
manipulate parts of the numbers.
 
If you mean really big integers, then Excel has a built-in limit on the
number of digits you can use. If you format a cell to text or enter the
number as text, then you can have many, many more digits, but to do math on
them you will need special UDFs.
 
Excel will only handle 15 digitsin one number.
If you need more and and stand for it to be text, You can putt a ' in front
of it.
 
Jim: Is it possible to shell the Calculator (under Programs >
Accessories...) and get it to do the math? Calculator can handle more than
15 digits.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum amount of numbers in one Cell 2
I cannot enter a number containing more than 15 digits in Excel 1
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Entering More than 15 numbers 4
how can I sum up the values with more than 15 significant digits? 5
Excel Need Countifs Formula Help 0
Macro to add numbers in a text string 5
Number of Completed Months 3

Back
Top