How can I change dates to mmddyy?

Closed
larango2006 Posts 1 Registration date Monday August 6, 2012 Status Member Last seen August 6, 2012 - Aug 6, 2012 at 08:49 AM
ExcelJosh Posts 12 Registration date Wednesday August 8, 2012 Status Contributor Last seen October 12, 2012 - Aug 8, 2012 at 10:01 AM
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 August 8, 2012 Status Contributor Last seen October 12, 2012
Aug 8, 2012 at 10:01 AM
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
0