QueryTable Field Name formatting
 

Is there any way to control the formatting on Field Names in a query
table? I'm hitting an ODBC source with a conditional sum query to
crosstab the data by date, but Excel refuses to recognize the field
names as dates, despite the data being properly formatted.

I can force the issue by looping through that row in VBA and setting
the value of the cell to itself, at which point Excel recognized the
data as a date, and formats it appropriately. It works, but seems to be
a rather crude hack, and I hate the idea of adding overhead that
effectively changes nothing.

Anyone have any better ideas?


---
Message posted from http://www.ExcelForum.com/