hi
in a blank cell off to the side, enter the number one(1). copy it. high
light the column of text dates. then paste special muliply. you may loose
your formating as it changes to number but can easily reformat to date.

regards
FSt1

"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