If you remove the formatting from the cell, does the data import correctly as a number? That might narrow down the possible issues and suggest a work around if it does.
The field type in FM is defined as "number," not "date"
Just to confirm the obvious, the field is defined as number in Manage | database | fields? (sometimes people think that the data formatting selected on the inspector tab determines a fieild's data type and this is not the case...)
Thanks for the quick reply. I took your suggestion and removed formatting in excel, and the data for those two fields imported correctly. The answer to your second question is "yes," the fields are defined as numbers at the Manage> Database> Fields level.
While your solution works perfectly, I'd like to understand what cause the problem so I can solve similar issues in the future (not to mention that I'd love to reintroduce the proper cell-level formating to my vendor item spreadsheet. Any ideas?
That would take someone with access to the source code to answer. I'm just a fellow user.
Please post this issue in the Report an Issue section. You can save typing by posting a link to this thread in that report. FileMaker techs should respond to that post and they may be able to provide more info about this issue. If you can upload a sample excel file to a file sharing site and include the download link in your post, it may help them better replicate the issue on their systems.