Date formatting

rjangamakote Posts 1 Registration date Monday May 23, 2016 Status Member Last seen May 23, 2016 - May 23, 2016 at 12:38 PM
 Blocked Profile - May 23, 2016 at 04:35 PM
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:

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 response

Blocked Profile
May 23, 2016 at 04:35 PM
Um, I would like to help, but Month/Month/Year is not an acceptable format.

You can format text like this:


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