Previous Topic Next Topic

Date formatting

Closed
rjangamakote Posts 1 Registration date Monday 23 May 2016 Status Member Last seen 23 May 2016 - 23 May 2016 à 12:38
 Blocked Profile - 23 May 2016 à 16:35
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 response

Réponse 1 / 1
Blocked Profile
23 May 2016 à 16:35
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!

Similar discussions

Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response