View Single Post
 
Old 09-03-2018, 05:22 AM
t_hudson@hotmail.com t_hudson@hotmail.com is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2017
Posts: 9
t_hudson@hotmail.com is on a distinguished road
Default Tired of 3-Sep default date

Using Excel 2016 on Windows 10.1803. Is there any way to permanently set the default date format to mm/dd/yyyy? I know how to adjust the format AFTER I enter a date, but the only format I ever use is mm/dd/yyyy, and 3-Sep never made any sense as a usable date anyway. Is there some way to set the default, so I don't have to change the format every time I add a column with dates in it?
Reply With Quote