Format a cell with numbers and user defined text

[Rod R.]

I want to format a cell that will take user defined numbers and text in the
following format: 12345678-A
Another example would be: 23454368-X

The numbers, dash, and text refer to Medicaid identification numbers and I
want to be able to have a constant format when these values are entered.

[pinmaster]

Hi
Assuming the dash will always be second to last, you can use conditional formatting. Select your columns where these numbers will be inserted then go to Format/Condtional Formatting and choose Formula is from the drop down menu and use this formula.....

=LEN(FIND("-",RIGHT(A1,2)))

A1 refers to the first cell in your selection. Choose your format and hit OK.

Hope this helps!
JG