custom formats (xxx-0000)

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 09:50:01 -0700

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.
>
>Any help on trying to do this would be greatly
appreciated. Thanks.
>.
>