It's easy to change the date format in Microsoft Excel. ... The long date option adds the day of the week and writes out the month. So 1/1/19 will display as Tuesday, January 1, 2019.

Use the Short date, Long date, Short time, Long time, and First day of the week dropdown menus to choose the right format for each one. Preview the changes under Examples . Click OK to confirm ...

The long date option adds the day of the week and writes out the month. So 1/1/19 will display as Tuesday, January 1, 2019. The date will display in the format you choose, no matter how you enter it.

The most frequently occurring problem caused by this issue relates to sorting date lists composed of dates both before and after Jan. 1, 1900. To sort pre- and post-1/1/1900 dates, you can reformat ...