Problem Maintaining Cell Format After Query

M

Mike

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Format change in merge data - Bold formatting after a comma 0
Difficulty with compatibility mode and Track Changes 2
Maintaining Cell Format in Query 2
List all tables, including document structure 0
Peculiar default cell format 1
VBA - exporting serial letters to single documents 0
Embed the same Excel multiple times 0

Top