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
|