Entering a 16 digit number

[Tbird]

I am creating an Excel worksheet and am trying to enter credit card numbers
in one of the columns. When I enter the number, it automatically changes the
last digit to a "0". How do I format the cells to accept a 16 digit number?

[Peo Sjoblom]

Format as text or precede the entry with an apostrophe, excel has 15 digits
precision but I assume you won't do any calculations with credit card number

--
Regards,

Peo Sjoblom

(No private emails please)


"Tbird" <Tbird@discussions.microsoft.com> wrote in message
news:EF7E2877-8F24-4F80-883D-30C9679151FE@microsoft.com...
>I am creating an Excel worksheet and am trying to enter credit card numbers
> in one of the columns. When I enter the number, it automatically changes
> the
> last digit to a "0". How do I format the cells to accept a 16 digit
> number?