Hello Delaina,

Use a Custom Format ...

00"-"0000000

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"Delaina" wrote in
message ...

I am doing a report where 0 is the first number in the cell, but not for
every cell. So they look like this:

094521463
456245654
654621327

When I try to format it to put a hyphen between the 2 and 3rd numbers
the 0 erases.

Is there a formula that would allow me to change all the 9 digit
numbers I have to put the hyphen in?

I want...

094521463 09-4521463
456245654 to look like: 45-6245654
654621327 65-4621327

so when I mail merge the hyphen will show as well.

Thanks for the help!


--
Delaina
------------------------------------------------------------------------
Delaina's Profile:
http://www.excelforum.com/member.php...o&userid=24151
View this thread: http://www.excelforum.com/showthread...hreadid=477952