Deliver Mark Cc Number with airSlate SignNow

Justify credit card number field

hey welcome back to the dueling excel podcast I'm bill jelling from mr. excel will be joined by my Karen from Excel is fun this is our episode 122 entering credit cards in Excel well this is a really common problem people try and keep track their credit cards in Excel Annabeth is trying to enter credit card numbers and she's losing the last digit every single time here let's try it 4300 two two two two three three three three four four four four BAM that last four goes away can replace by a zero expiration date so we have an expiration date of two 2017 and we lose the leading zero three digit code one two three works great but Oh two three Loosli leaving zero all right the problem here is that Excel only deals with 15 digits of precision now this week on the mr. Excel podcast on Wednesday I had a number of 451 septillion there were so many digits that we lost you know everything after the first 15 digits and generally that's close enough but it's really frustrating with credit cards because we need that lasted to that last digit is really important yeah so what we're going to do is choose these cells here and actually going to do it all of these and go to the Home tab change from a number format to a text format text format says hey let me enter whatever I want don't try and treat it as a number don't try and use any of your Excel mojo on it it's just text let me have it 4300 - 2 2 2 3 3 3 3 4 4 4 4 and the last digit says if you had some other kind of part number you know that had 24 numbers oh yeah it's still going to work all right so it's just text now you can't do any math with it but that's ok and expiration date of a 1/16 it's going to stay exactly the way you enter with the leading 0 over here with the three-digit code I'm not gonna convert that to text I'm just gonna do control 1 and a custom number format of 3 zeros 1 2 3 like that and you see that then we enter Oh 2 3 now I need to copy that formatting down here custom I'll take three I could have doesn't pay special formats but just as fast all right so let's try something else 3d 702 2 2 2 3 3 3 3 4 4 4 4 it stays and a 117 stays and Oh 47 stays there we go a little bit of formatting will allow you to do those credit card numbers with all their sixteen digit glory all right Mike let's see what you have thanks mr. Excel hey text number formatting custom number formatting zero zero zero that really is the way to go however there's an amazing array formula that can convert oh wait a second oh that's a joke there's no array formula for this problem this is as mr. Excel says 15 digits that's all Excel is going to see so we have to use text alright so you used number formatting you know I suppose I could come here I'm gonna hit the Delete key to delete content and then I'm gonna come up here and apply general it if you use a lead apostrophe then it doesn't matter what the number format is it is considered text so lead ' and then Oh 1/15 lead apostrophe and then zero zero five all right no array formula here just lead apostrophe throwback to mr. Excel Mike that's beautiful this is a record this is the first dueling podcast in months where you haven't kicked out in the rain for a minute I haven't kicked out some vba just simple number formatting lead apostrophe I love that that I'm gonna bore you since we have so much time here going back to the days of Lotus 1-2-3 there were actually three characters a lead apostrophe would say to left justify a lead double quote would say to right justify and a lead caret shift six that little hat there would say to Center the entry so those were at Lotus 1-2-3 formatting commands and so the lead apostrophe still works to this day in Excel well hey I want to thank everyone for stopping by we'll see you next time for another dueling excel podcast from mr. excel and excel is fun