O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and 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 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 to one of the 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.

Note

At the top of the list of date and time formats are several types that begin with an asterisk (*). These formats respond to changes in the settings available on the Date and Time tabs in the Customize ...

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