I am using excel 2013 and I have donwloaded an excel file which has a date column but some of the dates wont change format to date format.
See example below
Purchase Date
01-03-13
01-04-13
01-08-13
01-09-13
01-10-13
1/14/13
01-11-13
The second last one from the bottom 1/14/13 will not chnage to look like the othesrs and thefore I cannot pick it up in the pivot table. I have tried to use text to columns whihc normally works but will not in this case
See example below
Purchase Date
01-03-13
01-04-13
01-08-13
01-09-13
01-10-13
1/14/13
01-11-13
The second last one from the bottom 1/14/13 will not chnage to look like the othesrs and thefore I cannot pick it up in the pivot table. I have tried to use text to columns whihc normally works but will not in this case