View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
G Henry[_2_] G Henry[_2_] is offline
external usenet poster
 
Posts: 3
Default CC number both AmEx and Visa

I need to format a column so when users enter the 15 digit American Express
or 16 digit Visa/MC it will display the number in the correct format
visa/MC xxxx-xxxx-xxxx-xxxx
AmEx xxxx-xxxxxx-xxxxx
Also we need to be able to select and copy the data to paste and it must
have no characters except for the numerical digits.

Also how do I format a column for the credit card date (MM/YY)?
Can this be done?
-Gordon