can’t figure out how to format cells numbers to social security number (123-45-6789). Could use text but rather use as a number for sorting, etc.
I might suggest to treat “numbers” of the kind as texts. I hope nobody urgently needs to calculate with an SSN (or a phone number). Why then treat it as a number?
Having a SSN in cell A2 e.g. you may enter into a free cell (say B2) the formula
=IF(ISNUMBER(A2);TEXT(A2;"000-00-0000");A2)
to get the SSN as text if it was entered as a number, and also if it already was text.
Having a column of SSN then, you can copy it and paste the results (without the formulas) elsewhere using ‘Paste Special…’.
Hello,
Select Number for Category. Then on Format Code line enter 000-00-0000.