Credit Card Number Formatting

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi Folks - In Excel 2002, if I enter a 16 digit credit card number, Excel
will display the first few digits appended with E+15. Is there a way to
force Excel to display the 16 digits without entering a single quote first?
Thanks.

Mike
 
Since you are not doing any calculations with these numbers precede the
entry with an apostrophe,
that will make it text but the limits with regards to numbers (limit is 15
digits) is not there.
You can also format the cells as text before you enter the numbers
 
Apostrophe is the same as a single quote.

But an alternative is to format the column as text ahead of time.

--
 
But an alternative is to format the column as text ahead of time.
Click to expand...

Which I also mentioned:

" You can also format the cells as text before you enter the numbers"



--

Regards,

Peo Sjoblom


"
 
Okay, guilty as charged. (no criminal or civil penalties involved).

I'll just mention in passing that 15 digits for numbers is a specification
limitation and cannot be overridden. Specification Limits can
be seen in HELP under "specification".
 
Don't you hate it when someone doesn't read all your post--including the last
portion!!!!

(hehehehe)
 
Back
Top