upload ID in text from from excel - filemaker changes to number
As I've done with version 7, I uploaded excel file in filemaker 10 and the ID number (as text in excel) gets changed to a number which never happened in FM 7.0. now I can't match IDs becasue the beginning zeros are missing. I don't want them missing how do I fix that? ex. 00123456 in excel - text format shows up as 123456.