gemini9189 Posted February 28, 2006 Posted February 28, 2006 Hi!! I am trying to import a contact list from excel into FMP, v. 7 - After I import it, any zip code that starts with a 0 (zero) does not disply the 0. Also, I cannot inport the dashes it seems, but that is a minor thing. The main thing is the zero. i.e. imported 04875-1566 displays 48751566 Is there any way of doing an exact import to import exactly what is in the excel file? Thanks a million - Gemini9189
musicarteca Posted February 28, 2006 Posted February 28, 2006 make sure that your zip code is of type text and not number.
gemini9189 Posted February 28, 2006 Author Posted February 28, 2006 I have tried that already - It doesn't work - Any other ideas?
Lee Smith Posted February 28, 2006 Posted February 28, 2006 (edited) The field MUST be text result, by chance are the 0s missing before you import? Is the Field a Number in Excel? You might try changing it to Text and see what happens. Lee Edited February 28, 2006 by Guest
gemini9189 Posted February 28, 2006 Author Posted February 28, 2006 Actually I just figured it out. The field was a text field with a formula in excel. What I did to make it work was save the entire excel file as a .csv first - Then it imported very easily. I appreciate all of your help though!! Gemini9189
Recommended Posts
This topic is 6862 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now