Reformatting dates as text

[AmyTaylor]

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

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

Thanks for any advice
Amy x

 

[Guest]

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: