View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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