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

Sounds like these are not numbers that you will do any math operations
on so you can treat them as text. Select all the cells and
FormatCellText. You may have to go back and add the 0 at the front.
You can use ASAP Utilities to add the zero to all the cells at once.
See 'Asap Utilities' (http://www.asap-utilities.com/) . Asap Utilities
is a free Excel Add-In.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=477952

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