I want to store credit card numbers ( 16 digit ) in Excel sheet. I would like to have it displayed the way it is printed on the card ( in cluster of 4 digits separated by spaces or dashes eg. xxxx xxxx xxxx xxxx ). I can format the cell as Text and then enter the number with intervening spaces. But I also need to cut and paste these credit card numbers to other application where intervening spaces are not accepted - it accepts only 16 digits with no other characters in between. Thus the cell should store 16 digit number ( as number or text ) without any spaces but then display the same number in the cell with intervening spaces ( or dashes ). I have Office 2007. Pl help.
Veerkar
Bookmarks