I have a spreadsheet that has social security numbers in one of the columns:

'123345678 this is how they are displayed in the formula bar when I
select a cell. If I try to format them as 123-45-6789 the formatting
doesn' t work. The number is still displayed as '123345678. What am I
doing wrong?

Thanks