Date showing as number in MS Query

[tech2]

I have a workbook that I'm using as my data source for MS Query. My problem is MS Query is showing 11/4/2011 as 40851. I've tryed fromating the entire Column as Date with no success. I've also made sure the excel option 'Show formulas in cells instead of their calculated results' is unchecked. Using excel 2007.

thx,

tech2

 

[Matt Rogers]

Hi.

Turn off "Error Checking".
Sometimes it helps.

 

[tech2]

Hi Screwdriver

Turning off Error checking did make a differance.
Thanks for your suggestion.

 

[tech2]

Hi Screwdriver

Mistake in previous reply!

Turning off Error checking did not make a differance.
Thanks for your suggestion.