Hi Mike

Post the query that you are using, and what is in the cells involved in the
query.

--
Regards
Roger Govier

"Mike" wrote in message
...
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.