### Title

Lost Zero

### Post

I am extracting the last four digits of a social security number into a calculation field. Works perfectly in FileMaker; however, when exporting into Excel, if the first digit (of the last four digits) is a zero, the zero will not post into Excel. This is an Excel problem, but thought someone might have seen this before. Is there a cell format that will populate the zero once I open Excel?

Thanks,

Hal

Are the last four digits in a field separate from the full SSN?

If so, Excel is treating this as a number instead of text.

Are you exporting from a text (or text calculation) field in FileMaker?

If so, try including a single quote before the 4 exported digits to get Excel to treat the data as text instead of a number.