Reformatting dates as text
 

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

Reformatting dates as text
 

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