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.