| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I type in a 16 digits (credit card) end 02 it auto change 00.
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I type in a 16 digits (credit card) end 02 it auto change 00.
Excel can only handle numbers up to 15 digits.
Since your credit card number isn't really a "number", it's an ID.... Either set the cell's number format to TEXT <format<cells<number tab Category: Text OR Prefix the Credit Card Number with an apostrophe ( ' ) Does that help? *********** Regards, Ron XL2002, WinXP "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Template to track credit card expenses and expense reports combi | Excel Discussion (Misc queries) | |||
| How long will it take to pay off my credit card | Excel Discussion (Misc queries) | |||
| Formula to figure credit card payments | Excel Worksheet Functions | |||
| Custom Function not being auto calculated when cells change..help? | Excel Worksheet Functions | |||
| Is it possible to change the blue colour of an activated Auto Filter button? | Excel Discussion (Misc queries) | |||
Linear Mode
