Excel 2007 Formatting Column of Numbers to Social Security Format
Posted on 2014-02-10
I have a column of numbers (column A) that are social security numbers and need to be in SSN format. For some reason the custom SSN format is not working on these numbers. They appear in SSN format in the column but on the formula/number bar they are missing the dashes.
Can someone provide a formula that will look at 9 digits of numbers and add the necessary dashes so its in SSN format? Im guessing a left mid right string?