Hi All
I have a spreadsheet whicj I need to do some analyis. I have a column which show the dates as below
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
2014/12/21
These are not exported as dates, i think they are as texts format. I need to merge some cells but before I do that to create a unique value I need tihe dates above to be shown in the form of 21/12/2014 i.e. dd/mm/yyyy. As these are not in the dates format is there anyway I can flip the values around to the reuqired format
I need these urgently as I have over 20000 lines of data to compkare
Thanks
Bookmarks