Thread
:
How to format text and numbers as custom
View Single Post
#
2
Don Guillett
Posts: n/a
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?
Reply With Quote