social security numbers

How do I change social security numbers so that all the dashes are removed?
thank you for your help in advance.
Jean

Have a look in HELP for SUBSTITUTE

--
Don Guillett
SalesAid Software
[email protected]
"Jean" <[email protected]> wrote in message
news:[email protected]...
> How do I change social security numbers so that all the dashes are
removed?
> thank you for your help in advance.
> Jean

Thank you, I did look there first but cannot understand how to convert the
format from dashes to no dashes, even after looking at that section of the
help. I have 800 records to convert and do not want to have to go in and
delete all the dashes if I can do it an easier way!

"Don Guillett" wrote:

> Have a look in HELP for SUBSTITUTE
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Jean" <[email protected]> wrote in message
> news:[email protected]...
> > How do I change social security numbers so that all the dashes are
> removed?
> > thank you for your help in advance.
> > Jean
>
>
>

Maybe just select the range with the SSNs with dashes and

Edit|replace
what: - (hypen)
with: (leave blank)
replace all

Then format it as a SSN (format|cells|number Tab|special|SSN)

as a formula that returns text:
=substitute(a1,"-","")
or as a formula that returns a number:
=--substitute(a1,"-","")



Jean wrote:
>
> Thank you, I did look there first but cannot understand how to convert the
> format from dashes to no dashes, even after looking at that section of the
> help. I have 800 records to convert and do not want to have to go in and
> delete all the dashes if I can do it an easier way!
>
> "Don Guillett" wrote:
>
> > Have a look in HELP for SUBSTITUTE
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Jean" <[email protected]> wrote in message
> > news:[email protected]...
> > > How do I change social security numbers so that all the dashes are
> > removed?
> > > thank you for your help in advance.
> > > Jean
> >
> >
> >

--

Dave Peterson

try this macro after selecting your range with the numbers

Sub deletedash()
For Each c In Selection
c.Value = Application.Substitute(c, "-", "")
Next
End Sub

--
Don Guillett
SalesAid Software
[email protected]
"Jean" <[email protected]> wrote in message
news:[email protected]...
> Thank you, I did look there first but cannot understand how to convert the
> format from dashes to no dashes, even after looking at that section of the
> help. I have 800 records to convert and do not want to have to go in and
> delete all the dashes if I can do it an easier way!
>
> "Don Guillett" wrote:
>
> > Have a look in HELP for SUBSTITUTE
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Jean" <[email protected]> wrote in message
> > news:[email protected]...
> > > How do I change social security numbers so that all the dashes are
> > removed?
> > > thank you for your help in advance.
> > > Jean
> >
> >
> >