Credit Card Number Formatting

[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

 

[Peo Sjoblom]

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

 

[David McRitchie]

Apostrophe is the same as a single quote.

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

--

 

[Peo Sjoblom]

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

Which I also mentioned:

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



--

Regards,

Peo Sjoblom


"

 

[David McRitchie]

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".

 

[Dave Peterson]

Don't you hate it when someone doesn't read all your post--including the last
portion!!!!

(hehehehe)

 

[Peo Sjoblom]

Maybe his beard was in the way reading that low

 

[Dave Peterson]

Or I may have been tossing a stone at someone else <gd&r>.

(If you recall!!)

 

[Peo Sjoblom]

I recall you

--

Regards,

Peo Sjoblom

Or I may have been tossing a stone at someone else <gd&r>.

(If you recall!!)