How do I create a macro to put "-" between existing numbers?

I have a spreadsheet containing Social Security numbers. All need to be in
the format ###-##-####. How do I create a macro to do this on a cell that
has the format #########?

So far what I get is that the macro changes the SS# to be the same as the
one I changed when creating the macrol.

Why not just do it with a custom format. Select the area you want to modify
and right click. Choose Format Cells. Choose Custom. Type in 000-00-0000...
--
HTH...

Jim Thomlinson


"Steverino" wrote:

> I have a spreadsheet containing Social Security numbers. All need to be in
> the format ###-##-####. How do I create a macro to do this on a cell that
> has the format #########?
>
> So far what I get is that the macro changes the SS# to be the same as the
> one I changed when creating the macrol.

Thanks for the help. However, I am creating a spreadsheet to use as an
import to setup a database. I therefore actually need to insert the dashes.

"Jim Thomlinson" wrote:

> Why not just do it with a custom format. Select the area you want to modify
> and right click. Choose Format Cells. Choose Custom. Type in 000-00-0000...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Steverino" wrote:
>
> > I have a spreadsheet containing Social Security numbers. All need to be in
> > the format ###-##-####. How do I create a macro to do this on a cell that
> > has the format #########?
> >
> > So far what I get is that the macro changes the SS# to be the same as the
> > one I changed when creating the macrol.