Cell format of A-N

B

Brad E

Is there a "Custom" format I can use to get one alpha
character, dash, one single digit number? e.g.: A-1, T-2.

If so, would it also be able to change an entry of A1 to A-
1?
Brad E.
 
R

Richard O. Neville

Don't see why you need any special formatting. Just type A-1, T-2, etc. You
can still sort these entries. I see no way to insert -'s where they don't
now exist, however; you'll have to do it manually.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top