Question: how to change date format in excel to short date?
Answer: Select the dates you want to format.
On the Home tab, in the Number group, click the little arrow next to the Number Format box, and select the desired format - short date, long date or time.