I have a file that has the dash in the social security number of the people
in the spreadsheet. I want to remove the dash without having to enter the SS
# again. I have tried the format but all that does is apply a format to the
cell. When I remove the format the dashes still remain?

Any help would be greatly appreciated!