Page 72 - Ms Excel Note and Workbook
P. 72
MICROSOFT EXCEL NOTE AND WORKBOOK
Other date formatting options
To access other date formatting options, select the Number Format drop-down menu and
choose More Number Formats. These are options to display the date differently, like including the
day of the week or omitting the year.
The Format Cells dialog box will appear. From here, you can choose the desired date formatting
option.
TIP
As you can see in the
formula bar, a custom date
format doesn't change the
actual date in our cell—it
just changes the way it's
displayed.
63 | P a g e