Import Record shows odd Format
I'm importing records into FMP11 from an excel spreadsheet. Very basic. And everything is working fine except one field is bringing in what looks like a formula rather than the text that is in the field. See images below:
The image on top is what my excel file shows. The image on the bottom is what comes into FM. Keep in mind I have other data in this same column that looks very similar (LE Studio - Misc 076900151) which works just fine. The cell in excel is a text format. I thought maybe it was the dash, but I took that out and it didn't help (and it didn't affect the cell that did work).
Any ideas? Do you need more information?
update: fixed. I had to change the format of the field in FM to "as entered."