SSN formatting

[dboatrt]

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 greatly appreciated.

db

 

[c_m_s_jr]

Worst case scenerio you can use a formula in the column next to SSN

Assuming SSN is in Column A and Row 1 is header

=LEFT(A2,3)&"-"&MID(A2,4,2)&"-"&RIGHT(A2,4)

 

[Bill Rockenbach]

USe excel's custome formatting with 000-00-000#

 

[xenou]

Why do you need them in this format?

If custom formatting/number formatting doesn't work, its likely these are interpreted by Excel as TEXT values rather than NUMBER values.

This should be the right custom format for text:
???-??-????

And for numbers:
000-00-0000

And (maybe) for either:
000-00-0000;;???-??-????