You're Awesome, Dave...!

Thanks so much.

Kindest Regards,

Dawn

"David Billigmeier" wrote:

So do you want to keep the 0's appended on the front? If so, use:

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

If not (you want the 0's in front of the number to be taken out) use:

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


--
Regards,
Dave


"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.