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
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.
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.
Related:
- Date formatting
- How to change date format in excel - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Excel conditional formatting based on date - Guide
