How to Change the Regional Format in Excel for the Web (UK Dates)
Excel for the web decides how to read a typed date like 02/10/2026 from its regional format. Set to English (United States), that's 10 February; set to English (United Kingdom), it's 2 October. Change it before you enter any dates: File → Options → Regional Settings.
