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
   67   68   69   70   71   72   73   74   75   76   77