Converting to date format

  • Thread starter Thread starter ahaigh
  • Start date Start date
A

ahaigh

Hi,

I have an Access table with a selection of monthly reports in. These
are labelled "November 2005" for example in one of the coumns.

I would like to be able to simply copy this table from Access into an
Excel worksheet. However, when I've done this Excel will not recognise
"November 2005" as a date in any way.

Is there any way in excel I could alter "November 2005" to an excel
date format? (eg "Nov-05") I've tried to set this up in Access without
any success.

Any suggestions would be greatly appreciated.

Thanks,
 
One suggestion would be to create a Find/Replace Macro.

Find January > Replace with: Jan-
Find February > Replace with: Feb-
 
Back
Top