>>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.
I'm using COPY TO (myXLS) TYPE XL5 command to produce XLS, then I apply formatting. My SSN is a character field.
Anyway, I've changed it to pre-format the field in advance when I prepare my data.
Also if SSN is Numeric, it works, but then the data is right aligned.
If it's not broken, fix it until it is.
My Blog