I have created a VBA form to enter data into a table. one of the data fields is a date, but it keeps entering the data as mm/dd/yyyy, but I need it to be entered as dd/mm/yyyy. If I change the column to “text” it shows how I want it, but when I use “sort” the date is sorts by number descending not date descending. Is there a way to change the date to dd/mm/yyyy?