S sunnyp Member Jun 10, 2012 #1 How to do credit card number format in excel through vba. I tried other formula it did not work , problem is last digit turn in to 0.
How to do credit card number format in excel through vba. I tried other formula it did not work , problem is last digit turn in to 0.
Hui Excel Ninja Staff member Jun 10, 2012 #2 Sunnyp Most Credit card numbers are 16 digits and excel can only support 15 digits You must therefore store and display 16 Digits Credit cards as text Refer: http://chandoo.org/wp/2009/04/07/using-credit-card-numbers-in-excel/
Sunnyp Most Credit card numbers are 16 digits and excel can only support 15 digits You must therefore store and display 16 Digits Credit cards as text Refer: http://chandoo.org/wp/2009/04/07/using-credit-card-numbers-in-excel/
