Custom format for Driver License Number

[Gregc]

I am trying to make a custom format for a license the format it A-111-111-111-111 . The problem is the letter. How do I make a custom format that puts dashes between the letter and the number. I can do it if it is only numbers.

Thanks,

Greg

 

[Mark W.]

I am trying to make a custom format for a license the format it A-111-111-111-111 . The problem is the letter. How do I make a custom format that puts dashes between the letter and the number. I can do it if it is only numbers.

Thanks,

Greg

You'll need to enter the dashes or insert the dashes using a formula.

 

[Gregc]

Can I use formulas in a custom format? I can figure out how to make a formula in an adjacent cell, but I want to be able to type it in a cell and have it work like a telephone or social security number format.

 

[Mark W.]

>Can I use formulas in a custom format?

No.

> ...but I want to be able to type it in a cell and have it work like a telephone or social security number format.

You'll need a VBA macro.

 

[Gregc]

Ok.

Thanks for the help.

 

[ROBINSYN]

You can use the custom format. I do it with my Purchase Orders to create unique codes for different schools.

ie: 4-59IQ-123-PO

Once the cell is formated every entry appears as the above format

Just highlight the cell(s) you want formated, right click, choose custom for mat and enter: A-000-000-000-000

All numerical entries in this cell will be formated this way.

ie; Enter 123456789000

result: A-123-456-789-000

Hope that helps

 

[Mark W.]

You can use the custom format...

Custom formats only apply to numeric values...

...The problem is the letter. How do I make a custom format that puts dashes between the letter and the number. I can do it if it is only numbers

 

[nevillestoke]

Sorry to jump in at the last minute - uninvited and all - but I think there's some cross-discussion going on.

Robinsyn - I think your format only works because you are hard-coding the first character as "A", whereas, as Mark suggests, you can't use a custom format that mixes alpha and numeric based on GregC's request.