Import External data Formatting issues

[ridawg]

Hey,

I have an excel spreadsheet that queries another spreadsheet in another
excel file using the Import External Data - Database Query functionality. The
problem I'm having is that even though I selected Preserve formats the
formatting is not being preserved. In addition one of the columns contains
both numeric and text data. I've formatted this column as text but the data
is not coming through. I either get the numeric values (even though they are
formatted as text) or the text values depending on which values appear first.
I can seem to get all the values in this column.

Thanks!