Previous Topic Next Topic

Date formatting

Closed
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:
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

Answer 1 / 1
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:

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

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