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' (http://www.asap-utilities.com/) . Asap Utilities
is a free Excel Add-In.

 

[Zack Barresse]

Hello Delaina,

Use a Custom Format ...

00"-"0000000

HTH