I
igneramos
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?
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?