Try using Edit/Replace.
In the Replace what enter a -
In the with leave it blank
~Kristin

"Deb" wrote:

I need to convert SSN to number currently my cell has 111-11-1111 and
I need to format to numberican value of 111111111

Thanks for you assistance