I am having trouble formatting a column of SSN. I need them to be in the 123-45-6789 format. I have tried special formatting, custom formatting, and neither are working. I am using office 2007 but think the file sent to me is excel 2003 if this makes a difference.
Any help or advice is...