GCFLearnFree.org

I love your videos. Everything is so precise and to the point.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2003
  • Formatting Numbers

Excel 2003

Single page view print copy

Formatting Numbers

Formatting time in the Format Cells dialog box

The time can be formatted in many different ways in Excel 2003. 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.

    The Number Tab on the Format Cells Dialog Box

  • Select the desired time format from the Type drop-down list.
  • Click the OK button.
previous next
previous 1 2 3 4 5 6 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.