O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Use the Number tab of the Format Cells dialog box to apply date and time formats to cells.

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required