Question: how to change regional date format in excel?
Answer: Open the Control Panel (usually found in the Start menu). Locate and select Change date, time, or number formats within the Clock, Language, and Region category. The Region dialog box will appear. Click Additional settings. The Customize Format dialog box will appear.