View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

If always H then custom format of "H"&000-etc should do it
or format as text and type in the - - - -
or a worksheet change event to convert based on any entered letter and
numbers entered witout - - -

--
Don Guillett
SalesAid Software

"Julian Ganoudis" <Julian
wrote in
message ...
How do you format a drivers license number? For example:
Hxxx-xxx-xx-xxx-x, where x represents any number, but "H" represents any

text?
Do you have to use a macro? If so, does anyone have the code for this
sequence?