Usually running the data though DataText to ColumnsNextNextColumn Data
FormatDate(choose format from dropdown)Finish will do the job.


Gord Dibben MS Excel MVP

On Tue, 7 Apr 2009 09:32:01 -0700, Judy Ward
wrote:

I am exporting from Access to Excel and ending up with a single quote in
front of the dates--which makes them a text field. This matters because I am
using the dates as a row source for a chart. If Excel knows they are Friday
dates, it fills in the missing Friday dates for me (which is what I want).

I have tried selecting the cells and formatting them as date fields and that
doesn't work. Manually removing the single quote in front of the date fields
has been the only thing that has worked, but I need to be able to do this in
code.

Does anyone have a solution for me?
Thank you,
Judy