How to change number formatting
 

Hi
Select your column and goto 'Format - Cells' and enter the following
custom format: "000-00-0000"

HTH
Frank

skrout wrote:
I have a spreadsheet that for Social Security #'s format requested
was for 000000000; now I have been asked to change to reflect the
formatting of 000-00-0000. Is there a formula that I can use that
change the formatting without having to retype over 1000 SS#'s.