>I set NumberFormat = "000-00-0000" I have SSN field data as character 9.
>It shows all the numbers without dashes despite the NumberFormat. Should I transform the value myself when I prepare data?

Hi Naomi,

How are you getting the data into the spreadsheet?

When I type 123456789 and then Format > Cells > Special > Socail Security Number (macro is Selection.NumberFormat = "000-00-0000" as you had) it works just fine. If I type 123456789 in another cell and copy/paste it into a pre-formatted SSN cell it brings the formatting from the source cell with it.