jeffdolton
Board Regular
- Joined
- Dec 21, 2020
- Messages
- 100
- Office Version
- 2010
- Platform
- Windows
Hello,
I deleted the custom format m/d/yyyy as Excel kept reverting to the US date format, when I want UK date format. As a consequence of this action, my table won't automatically expand, and code to colour certain columns in the table isn't working.
I use Windows 10 and have 2010 Excel. I have been into Windows settings and checked that the regional and language settings are set to English(UK).
I'm baffled by this and I would appreciate your help in fixing this.
Thank you.
I deleted the custom format m/d/yyyy as Excel kept reverting to the US date format, when I want UK date format. As a consequence of this action, my table won't automatically expand, and code to colour certain columns in the table isn't working.
I use Windows 10 and have 2010 Excel. I have been into Windows settings and checked that the regional and language settings are set to English(UK).
I'm baffled by this and I would appreciate your help in fixing this.
Thank you.