Date formatting [Closed]

Report
Posts
1
Registration date
Monday May 23, 2016
Status
Member
Last seen
May 23, 2016
-
 Blocked Profile -
I would appreciate if someone can help me here. When I export transaction list from a Bank Account for example, the dates for some reason appear in different formats. See the sample below:
01-08-16
01-03-16
12/31/2015
02/23/2016
03-07-16
03-11-16

They are all mmddyyyy, i would like to format all of them into mm/mm/yyyy. But for some reason it doesn't work for me. I am using Office 2016. I would appreciate your help.

1 reply


Um, I would like to help, but Month/Month/Year is not an acceptable format.

You can format text like this:

=Text(a1,"mm/dd/yyyy")

this wold give you the Month, day , year format!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!