I've encountered a troubling issue when importing data tables into InDesign from Excel. These are standard workbooks with named tabs. The value "-1.0" will not import into InDesign; it refuses. If I manually go into the Excel file and change the cell containing the value in question from "Number" to "Text" it will import, but this isn't scalable or possible when monthly reporting comes through and dozens of tables are flowed in automatically.
Is this a know bug? I can't seem to find any details online.
Macintosh 10.9.4, Indesign CC
I've also tested on InDesign CS6 and on Windows as well. I'm answering this/updating in an effort to help anyone else having the same issue.
I've continued troubleshooting and determined Excel files using the .xlsx extension are the main culprit.
All data imports fine when saved as .xls (97-2004)
I have also had problems with xlsx files. I have resorted to writing a script that converts all the xlsx files to xls (97-2004) in a batch so that I can import those instead.