Thread
:
Custom number format for driver's license number
View Single Post
#
5
Posted to microsoft.public.excel.misc
Excel User
external usenet poster
Posts: 34
Custom number format for driver's license number
That's unfortunate. You'd think MS would have the ability to store driver's
license numbers in their correct format. They should have the formats
pre-defined just as they do with "Social Securtiy Number" and "Zip Code".
It's pretty rare I find something that MS Excel cannot do. What about using
an event driven macro - would that work? How would it work? Would you be
able to use the same cell?
"Ron Rosenfeld" wrote:
On Wed, 16 Jul 2008 08:58:05 -0700, excel user <excel
wrote:
I need to create a custom number format for a wisconsin driver's license
number (i.e. "S123-4567-8912-34") How can this be done?
000-0000-000-00 will do for the numeric part of the number,
\S000-0000-000-00 will do for the above where the numeric part is preceded by
the letter "S". (You would just enter the numbers)
but I don't think you can have a variable preceding letter in the format.
If you put your letter in A1, and the number in B1, then perhaps:
C1: =TEXT(B1,"\"&UPPER(A1)&"000-0000-000-00")
--ron
Reply With Quote
Excel User
View Public Profile
Find all posts by Excel User