Export to Excel Text Format Change

[Dave H]

I am working with an Access querry export to Excel 2003. The export date
range comes over as text. I have tried to convert the text to a number off of
the cell error dialogue as well as custom formatting. It appears that the
format changes however when running a function it won't recognize the format.
I know the function works as I've run test cases without a problem. Is there
a way to change in Excel or do I need to change the querry attributes?

I appreciate any help.

Dave

 

[pietlinden]

I am working with an Access querry export to Excel 2003. The export date
range comes over as text. I have tried to convert the text to a number off of
the cell error dialogue as well as custom formatting. It appears that the
format changes however when running a function it won't recognize the format.
I know the function works as I've run test cases without a problem. Is there
a way to change in Excel or do I need to change the querry attributes?

I appreciate any help.

Dave

what if you format the column in question as a date? Access does
store dates as numbers internally... the integer part is the number of
days since day 0 and the rest is a fraction of 24 hours (a time).