Formatting Dates and Times
After you enter a date or time in a cell, you can choose Format, Cells and click the Number tab to change its format using any of Excel's built-in formats. Choose Date or Time in the Category box 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 of the Format Cells dialog box to apply date and time formats to cells.
Note
At the top of the list of Date and Time formats there are several that begin with an asterisk (*). These formats respond to changes in the settings available ...
Get Microsoft® Office Excel 2003 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.
