Thread
:
Custom number format for driver's license number
View Single Post
#
4
Posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
Posts: 5,651
Custom number format for driver's license number
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
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld