View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Excel User Excel User is offline
external usenet poster
 
Posts: 34
Default Custom number format for driver's license number

I tried it, with no success. Also, The "S" is not static, I need it to
display whatever letter I type.

"RagDyeR" wrote:

Assuming quotes ( " " ) not needed:

\S###-####-####-##
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"excel user" <excel wrote in message
...
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?