custom formats (xxx-0000)

[Frank Kabel]

Hi
AFAIK this is not possible with formats. One workaround:
Use a helper column with a formula like
=LEFT(A1,3) & "-" & MID(A1,4,200)

-----Original Message-----
I'm trying to make a 3 letter, 4 number code such as

PMP3010 to automatically add a dash between the number and
the letters. For example. I would like PMP3010 turn into
PMP-3010.