Hi Amy,
Format the cell in custom formatting like mmmm dd, or if you want a copy of
(say A1) source cell as a real text cell then use =Text(A1,"mmmm dd") in the
destination cell!
Regards,
Stefi
€˛AmyTaylor€¯ ezt Ć*rta:
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