Formatting Dates and Times
After you type a date or time in a cell, you can use the Number Format drop-down list on the Home tab on the Ribbon to change its format using the most popular date and time formats, or you can click More Number Formats at the bottom of the list to select any of the built-in formats. In the Format Cells dialog box, select the Date or Time category to display the list of available formats in the Type box on the right. A preview of the format appears in the Sample box in the upper-right corner, as shown in Figure 15-4.
Figure 15-4. Use the Number tab in the Format Cells dialog box to apply Date and Time formats to cells. ...
Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
