You have a great deal of flexibility in formatting cells that contain dates and times. For example, you can format the cell to display the date part only, the time part only, or both the date and time parts.

You format dates and times by selecting the cells and then using the Number tab of the Format Cells dialog box, as shown in Figure 16-1. To display this dialog box, click the Dialog Box Launcher icon in the Number group of the Home tab. Or, you can click the Number Format control and select More Number Formats from the list that appears.

The Date category shows built-in date formats, and the Time category shows built-in time formats. Some formats include both date and time displays. Just select the desired format from the Type list and click OK.

FIGURE 16-1
Use the Number tab in the Format Cells dialog box to change the appearance of dates and times.

When you create a formula that refers to a cell containing a date or a time, Excel automatically formats the formula cell as a date or a time. Sometimes, this automation is very helpful; other times, it’s completely inappropriate and downright annoying. To return the number formatting to the default General format, choose Home?Number?Number Format, and select General from drop-down list Or, use this shortcut-key combination: Ctrl+Shift+~.

If none of the built-in formats meets your needs, you can create a custom number format. Select the Custom category and then type the custom format codes into the Type box.

• Dragon's Kiva Lending Team I want to recruit you to our lending team, One World, Many Paths, on Kiva, a non-profit website that allows...
• Should I Sell My Car On eBay? This article is by staff writer Adam Baker. Follow Baker on Twitter @ManVsDebt or connect with him on Facebook. Over...
• Maxam Portable Wood Putter User Reviews Send this to a friend Maxam Portable Wood Putter Manufacturer: Dashlynn Customer Rating: List Price: $47.95 Sale Price:...
• Top Best 100 Incredibly Useful & Free Mac Apps [/caption] Everyone loves free applications. One of the greatest things about Macs is the wealth of extremely talented developers that...
• Red Nag Champa - 100 Gram Box - Shanthimalai Incense User Reviews Send this to a friend Red Nag Champa - 100 Gram Box - Shanthimalai Incense Manufacturer: Shanthimalai Customer...