I have this problem that the cell format in the query result changed from the
source document. For example, when I run a query on a date field, the display
result will be shown as numbers. I have to keep reformatting the cell
everytime I run new query, and refreshing the data.

How do I retain the format in a query to be exactly as the source document?
To add headache to my problem, I have both numbers and date on the same
field, therefore I cannot format the whole column as date.

I'm using Excel 2003, and source document also in Excel 2003 format.

Thanks in advance for your expert tips.