AnsweredAssumed Answered

Lost Zero

Question asked by hferrell on Dec 17, 2013
Latest reply on Dec 17, 2013 by hferrell

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

Outcomes