Forum Discussion
janey273
Aug 30, 2019Copper Contributor
Help sorting database by date
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/...
SergeiBaklan
Aug 30, 2019Diamond Contributor
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.