Hi, I'd like to set the default date format for all Excel files to be dd/mm/yy. When I type in a date it (eg 24/9) it displays as 24-Sep.
My regional settings are English (United Kingdom) and the location is UK. The short date is set to dd/mm/yyyy.
I know I can change this per cell/group of cells, but I'd like to change it so the default for all new sheets is dd/mm/yy