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

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 changes the last number I type in column???
 

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" wrote in message
...
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 changes the last number I type in column???
 

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.

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
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 changes the last number I type in column???
 

Thanks Fred!!!
"Fred Smith" wrote:

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" wrote in message
...
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 changes the last number I type in column???
 

Thanks T !!!!

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
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 changes the last number I type in column???
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
Thanks T !!!!

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
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