Microsoft Office Tutorials and References
In Depth Information
Formatting cells containing dates
Formatting cells containing dates
In many cases, knowing when something happened is just as
important as knowing what happened. For example, if you run
a garden supply store or nursery, it’s useful to know that you
get most of your customers on the weekends but that you make
most of your large sales (most likely to landscape architects and
other stores) during the week. Excel recognizes when you enter
a date in a cell and applies the program’s default format to the
date. There are many date formats to choose from—pick the
one you like the best!
Set a date format
1 Select the cells that you want to format as a date.
2 Click the Home tab.
3 In the Number group, click the Format Cells dialog box launcher.
4 Click the Number tab.
5 Click Date.
6 Click the date format you want.
7 Click OK.
TIP You can apply the Short Date or Long Date format to a cell
by selecting the cell and then, on the Home tab, in the Number
group, clicking the Number Format box’s list arrow and selecting Short
Date or Long Date. If the cell you format contains the date August 2,
2013, the Short Date format displays it as 8/2/2013 and the Long Date
format displays it as Monday, August 2, 2013.
Search JabSto ::

Custom Search