Lesson 13 - Lesson 13: Formatting Numbers Page 1 By the end...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Lesson 13: Formatting Numbers Page 1 By the end of this lesson, learners should be able to: Format the display of numbers Format the date Format the time Format the display of percentages Page 2 Formatting Numbers in the Format Cells Dialog Box Numbers in Excel can assume many different formats: Date, Time, Percentage or Decimals. To Format the Appearance of Numbers in a Cell: Select a cell or range of cells. Choose Format Cells from the menu bar. (You could also right-click and choose Format Cells from the shortcut menu.) The Format Cells dialog box opens.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Click the Number tab. Click Number in the Category drop-down list. Use the Decimal places scroll bar to select the number of decimal places (e.g., 2 would display 13.50, 3 would display 13.500). Click the Use 1000 Separator box if you want commas (1,000) inserted in the number. Use the Negative numbers drop-down list to indicate how numbers less than zero are to be displayed. Click the OK button.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Lesson 13 - Lesson 13: Formatting Numbers Page 1 By the end...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online