Excel XP


Formatting Numbers
Formatting Time in the Format Cells Dialog Box
The time can be formatted in many different ways in Excel XP. Here are a few ways it can appear:
13:30
1:30 PM
To Format the Appearance of Time in a Cell:
- Select the range of cells you want to format.
- Choose Format
Cells from the menu bar.
- The Format Cells dialog box opens.
- Click the Number tab.
- Click Time in the Category drop-down list.
- Select the desired time format from the Type drop-down list.
- Click the OK button.