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

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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.
 
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.
 
Thanks Fred!!!
Fred Smith said:
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.
Click to expand...
 
Thanks T !!!!

T. Valko said:
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.
Click to expand...
 
Back
Top