View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.


In article ,
"The_Apprentice" wrote:

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!