Converting to date format
 

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,


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=521838

Converting to date format
 

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

Find January Replace with: Jan-
Find February Replace with: Feb-