I’m set to a UK locale and the dates are formatted correctly in that respect. However, the default format is for a 2-digit year (DD/MM/YY), and I would like it to default to a 4-digit year (DD/MM/YYYY). Is there anyway I can set this as the default?
Despite typing 4-digits (eg.
02/11/2013) it always reverts to the 2-digit format, until I manually set the formatting for that cell or column. Unfortunately I’m having to do this rather a lot it seems and it’s quickly becoming tedious.