Aug 29 2019 09:56 PM
Hi there
I have a database which has a column with enrol date. I am in NZ and our date formate is DD/MM/YYYY.
Currently the database is sorted by the number not date, ie 01/02/2019 comes after 01/01/2019. 02/01/2019 will come after 19/01/2019 !! I cannot change or sort anything because of an issue with the size of a merge cell. I have tried to find the merge cell using the find feature, but the result is there are no merge cells! Still unable to sort though as getting the same error message. Nasty loop I can't seem to find my way out of. Please can anyone help me? Probably a very simple solution.
thank you so much
Smiles, Janey
Aug 30 2019 04:13 AM
To unmerge the cells select your column(s) and click on Merge & Center icon on ribbon, it's not necessary to search which exactly cells are merged in the range.
And it looks as your dates are actually texts. To convert to dates select the column with dates, Data->Text To Columns.
Aug 30 2019 04:28 AM
Hope this helps!