how to reformat numbers
 

I have numbers entered as social security numbers I need to remove the
dashes. I have tried reformatting the cells but that doesn't work example
336-04-0000. How do I convert to just 33604000. I have thousands of numbers.
I am using microsoft

how to reformat numbers
 

Edit....find........ replace

find what...........-........
replace with .....leave this blank.
--
Greetings from New Zealand



"C.Loner" wrote in message
...
I have numbers entered as social security numbers I need to remove the
dashes. I have tried reformatting the cells but that doesn't work example
336-04-0000. How do I convert to just 33604000. I have thousands of
numbers.
I am using microsoft

how to reformat numbers
 

=SUBSTITUTE(A2,"-","") or
Edit/ Replace/ - / by / [leave blank]
--
David Biddulph

"C.Loner" wrote in message
...
I have numbers entered as social security numbers I need to remove the
dashes. I have tried reformatting the cells but that doesn't work example
336-04-0000. How do I convert to just 33604000. I have thousands of
numbers.
I am using microsoft

how to reformat numbers
 

=LEFT(A1,3) & MID(A1,5,2) & RIGHT(A1,4)
--
Gary''s Student - gsnu200765

how to reformat numbers
 

Thank you sooo much!! After spending hours on trying to figure this out, I
was able to complete the task in minutes.

"Bill Kuunders" wrote:

Edit....find........ replace

find what...........-........
replace with .....leave this blank.
--
Greetings from New Zealand



"C.Loner" wrote in message
...
I have numbers entered as social security numbers I need to remove the
dashes. I have tried reformatting the cells but that doesn't work example
336-04-0000. How do I convert to just 33604000. I have thousands of
numbers.
I am using microsoft