Hi everyone, I have a spreadsheet that has a huge list of dates
formatted in date format eg: 01/04/2005 (european notation) relates to
April 2005 (Apr-05).

What I would like is to have a formula that changes this to text in the
format April 05, May 05, Jun 05 etc etc.

Thanks for any advice
Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=484213