AnsweredAssumed Answered

Import Record shows odd Format

Question asked by Terri on Nov 8, 2011
Latest reply on Nov 8, 2011 by Terri


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?