MS Access report save as Excel file

[gwarnick]

When I save a MS Access report as an Excel file, Excel drops the leading 0 of the social security number. I tried several different formats for the SS# field, but still no luck. The ONLY way I've gotten it to work is to format the Access report SS# field as a SS# (with the dashes).
If this is the only solution, how do you convert the SS# in Excel with dashes to JUST a number string (with no dashes) and still retain the leading 0?

 

[luceze]

Gwarnick,
Your Excel solution is to put this formula in the field next to your social securtiy number.

=LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4)

Where A1 is the field with the formatted SSN.

 

[Pzoxic]

Actually, you can display it correctly using this format:
=TEXT(012345678, "000000000&quot
Or you can set your output to include a ' with the data.