LinkBack URL
About LinkBacks
Hello everyone,
I would like to create a custom format for entering driver's license numbers.
eg When I type a12341234512345, I would like it to appear as A1234-12345-12345.
Any help would be greatly appreciated.
Hello everyone,
I would like to create a custom format for entering driver's license numbers.
eg When I type a12341234512345, I would like it to appear as A1234-12345-12345.
Any help would be greatly appreciated.
Last edited by Gryphen957; 02-01-2012 at 11:15 AM.
Custom formats only applies to numbers as far as I can tell. You would need to employ a macro that watches that column an "retypes" anything entered in that column to the correct format. Would VBA be acceptable?
If so, click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Let us see where/what you need this. Be sure to provide all the specifics of driver's license numbers for your requirements.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I think you cannot do that.. a way is to have another column and reference it to those alphanumeric.
Say in A1 = a12341234512345
in B1 = =LEFT(A1,5)&"- "&MID(A1,5,5)&" -"&RIGHT(A1,5)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thought it might be something like that. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks