1 Reply Latest reply on Nov 8, 2011 12:44 PM by Terri

    Import Record shows odd Format

    Terri

      Title

      Import Record shows odd Format

      Post

      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?