GCFLearnFree.org

This is awesome. There is no excuse not to learn!”

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 date in the Format Cells dialog box

The date can be formatted in many different ways in Excel 2003. Here are a few ways it can appear:

October 6, 2003
10/06/03
10-Oct-03

To format the appearance of a date in a cell:

  • Select a cell or range of cells.
  • Choose Format Cells from the menu bar.
  • The Format Cells dialog box opens.
  • Click the Number tab.
  • Click Date in the Category drop-down list.

    The Number Tab on the Format Cells Dialog Box

  • Select the desired date 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.