excel changes the last number I type in column???

[Mike]

After setting up a worksheet for a budget, I type in the credit card numbers.
If the last number of the card is 3 for example, when I press enter to go on
to the next line, it changes it to 0. Anyone here know what I'm doing wrong?
Thanks so much for any help

 

[Fred Smith]

Excel supports only 15 numeric digits.

Either:
-- format your cells as text before you enter the number, or
-- precede your credit card number with an apostrophe (')

Regards,
Fred.

 

[T. Valko]

Excel will only allow numbers to 15 significant digits. After the 15th digit
it changes all the remaining digits to 0.

You have to enter the string of numbers as TEXT.

Either pre-format the cell as TEXT or precede the entry with an apostrophe
like this: '1234567890123456. The apostrophe will not be displayed in the
cell.

 

[Mike]

Thanks Fred!!!

Excel supports only 15 numeric digits.

Either:
-- format your cells as text before you enter the number, or
-- precede your credit card number with an apostrophe (')

Regards,
Fred.

 

[Mike]

Thanks T !!!!

Excel will only allow numbers to 15 significant digits. After the 15th digit
it changes all the remaining digits to 0.

You have to enter the string of numbers as TEXT.

Either pre-format the cell as TEXT or precede the entry with an apostrophe
like this: '1234567890123456. The apostrophe will not be displayed in the
cell.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks T !!!!