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 response

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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses