Have you ever come across a scenario where your dates in Excel are in the wrong format?<\/p>\n
Say you type in 01\/05\/2018<\/strong>\u00a0which actually means\u00a0January 5, 2018 <\/strong>in the US but it shows as May 1, 2018!\u00a0\u00a0<\/strong>It drives me nuts because the entire spreadsheet<\/a> of dates is interpreted incorrectly by Excel!<\/p>\n That happens because your computer’s region settings<\/strong> are in UK format and need to be changed to a US format.<\/p>\n Thankfully, there is an easy way to change your Windows<\/a> region & date settings\u00a0<\/strong>so that the dates will be interpreted correctly by\u00a0Excel!\u00a0<\/strong><\/p>\n Here I show you how you can do this.
\n