On Thu, 22 Dec 2005 07:45:03 -0800, LCDawn
wrote:

I want to take a spreadsheet that has numbers entered as social security
numbers and change the display to be a number series. Some of the numbers
begin with 0. I'd like to have all the dashes removed as well.


Assuming the values are TEXT and not formatted numbers, then:

=SUBSTITUTE(A1,"-","")

will return the string, with the leading zeros.

If you do not want the leading zeros, then

=--SUBSTITUTE(A20,"-","")

will convert the value into a number, and you can format it as you wish.

You could also use FIND/REPLACE to replace the "-"'s with nothing.




--ron