Thread: When I type in a 16 digits (credit card) end 02 it auto change 00.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default When I type in a 16 digits (credit card) end 02 it auto change 00.
Excel has a limit of 15 digits for numeric data so will need to enter your CC
number as TEXT. Set column format to TEXT and then enter your data.

"Christie" wrote:

When I type in a 16 digits (credit card) end 02 it auto change 00. I've
checked the auto word option and the field format and cannot get it to stop
the autochange.


Reply With QuoteReply With Quote