How can I change dates to mmddyy?

Closed
larango2006 Posts 1 Registration date Monday 6 August 2012 Status Member Last seen 6 August 2012 - 6 Aug 2012 à 08:49
ExcelJosh Posts 12 Registration date Wednesday 8 August 2012 Status Contributor Last seen 12 October 2012 - 8 Aug 2012 à 10:01
Hello,

I have a column of dates and I need to change them to "mmddyy" text format?

Thanks for your help.

1 response

ExcelJosh Posts 12 Registration date Wednesday 8 August 2012 Status Contributor Last seen 12 October 2012
8 Aug 2012 à 10:01
larango:

You should be able to highlight the column, right click, format cells, select custom, and create a custom field to be mmddyy.

I hope this helps.

Good luck,
Josh