<div>
You can also select the cells as they are, and go to Format Cells.. Number.. Custom and set the custom format as:<br />
000-000-000<br />
This should insert the dashes for you, but leaves the underlying numbers exactly as they were. &nbsp;On the sheet itself they will display correctly, but the formula bar will just show the &quot;bare&quot; number.
</div>


You can also select the cells as they are, and go to Format Cells.. Number.. Custom and set the custom format as:
000-000-000
This should insert the dashes for you, but leaves the underlying numbers exactly as they were.  On the sheet itself they will display correctly, but the formula bar will just show the "bare" number.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a column of numbers (column A) that are social security numbers and need to be in SSN format. &nbsp;For some reason the custom SSN format is not working on these numbers. &nbsp;They appear in SSN format in the column but on the formula/number bar they are missing the dashes.<br />
<br />
Can someone provide a formula that will look at 9 digits of numbers and add the necessary dashes so its in SSN format? &nbsp;Im guessing a left mid right string?<br />
<br />
Thanks!
</div>
</div>


Hello,

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?

Thanks!

Excel 2007 Formatting Column of Numbers to Social Security Format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.