EXCEL
 

EXCELL - CAN ONLY ENTER 15 DIGITS, ENTERING MORE SHOW ZERO'S??

EXCEL
 

Please do not post with CAPS Lock on it is hard to read and considered rude.

You should check your HELP and look up "specification limit"
these are limitations built in or limitations that Excel must work with.

You should not be using a numeric field for a credit card number for instance
because it is not treated arithmetically, you should be using identification
information at text.

When you enter a 16 digit credit card 'number' the first 15 digits are the most
significant digits and will be retained the 16th digit will appear as zero, there
is no way to extract that information from the arithmetic processor or storage
of the number. The last digit of a credit card number is a check digit which is
there as protection from accidental keying errors.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ZD" wrote in message ...
EXCELL - CAN ONLY ENTER 15 DIGITS, ENTERING MORE SHOW ZERO'S??