Hi fellas,
I'm struggling with something seemingly very simple. I have a date column in a terrible format and I cannot apply a normal date format to all rows. I don't really care if it would be mm/dd/yyyy or dd/mm/yyyy as long as it is the same for every entry. Whatever I tried with functions like RIGHT, TEXT, text to columns, clean formulas and then copy paste back etc didn't work. Alsol, even if I change the date format to the whole column, nothing is changedAny ideas ?
<colgroup><col></colgroup><tbody>
</tbody>
I'm struggling with something seemingly very simple. I have a date column in a terrible format and I cannot apply a normal date format to all rows. I don't really care if it would be mm/dd/yyyy or dd/mm/yyyy as long as it is the same for every entry. Whatever I tried with functions like RIGHT, TEXT, text to columns, clean formulas and then copy paste back etc didn't work. Alsol, even if I change the date format to the whole column, nothing is changedAny ideas ?
Close Date |
12/21/2016 |
5/15/2015 |
3/22/2017 |
12/29/2015 |
7/30/2014 |
6/23/2015 |
7/29/2014 |
5/28/2015 |
12-09-15 |
11/24/2014 |
03-08-17 |
7/28/2015 |
11-11-15 |
3/31/2016 |
2/24/2017 |
11/24/2014 |
4/17/2014 |
11/25/2016 |
3/24/2017 |
6/29/2016 |
11-11-15 |
08-01-15 |
3/28/2017 |
07-01-14 |
9/30/2014 |
09-09-14 |
02-02-17 |
9/30/2016 |
09-01-15 |
2/13/2015 |
11-02-16 |
05-06-14 |
<colgroup><col></colgroup><tbody>
</tbody>