Apr 15, 2010
Formatting dates in Microsoft Excel is easy, right? All you have to do is:
But what do you do if you want your own custom date format to show up in the options? The Excel Date Format MM/DD/YYYY won’t show up unless it is selected in the Windows Control Panel. Fortunately, this is an easy fix (instructions apply to Windows 7, but ought to be similar for Vista and XP):
Now go back to Excel, and there, right along with the other date formatting options, is your very own custom date format!
Other types of formatting are covered in our Excel 2007 and 2003 classes.