Hello all, I m using Excel 2007
Can anyone help me please on this issue
Column E:E is populated with Dates IE 12/06/12
In Column AP:AP I need to show as June 12 as a TEXT using the data from column E:E.
IE
12/06/12 June 12
14/12/12 Dec 12
09/02/11 Feb 12
Etc
This needs to be changed using VBA code and I think it can be done using Date Serial but I am unsure how to complete this.
Can anyone help me please on this issue
Column E:E is populated with Dates IE 12/06/12
In Column AP:AP I need to show as June 12 as a TEXT using the data from column E:E.
IE
12/06/12 June 12
14/12/12 Dec 12
09/02/11 Feb 12
Etc
This needs to be changed using VBA code and I think it can be done using Date Serial but I am unsure how to complete this.