Alphanumeric custom formats
There is no mask-edit in Excel for text -- your best bet would be to enter
the value elsewhere and reference that cell in a formula, like:
=LEFT(Z2,2)&"-"&MID(Z2,3,4)&"-"&MID(Z2,7,1)&"-"&RIGHT(Z2,3)
"May47" wrote in message
...
does anyone know how to create a custom format in Excel 2007 that will all
you to enter this: 123456B789 and it automatically changes it to
12-3456-B-789
The letter can change so the mask should be able to accomodate that. I
found one that will work if the letter is always the same - but it won't
work
if it's anything other than a B.
|