Zero's

[Delaina]

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!

[neopolitan]

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 Format>Cell>Text. 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 . Asap Utilities is a free Excel Add-In.

[Zack Barresse]

Hello Delaina,

Use a Custom Format ...

00"-"0000000

HTH

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



"Delaina" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>