how about using SUBSTITUTE

--
Don Guillett
SalesAid Software

"catrose" wrote in message
...
How do I remove the dashes from SSN's on a spread sheet? They are NOT
setup
as '111-11-1111 I also have a lot of SSN's that start with
00X-XX-XXXX
and I still need the 0's (zeroes) to show.