Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

Type numbers into a worksheet

NOTE Be careful not to type non-numeric characters into cells containing numbers you want to use in calculations, otherwise Excel treats the whole entry as a text entry and you will not be able to use the number part of the entry in calculations. Only the characters 0 through 9, dollar signs ( $ ) and commas ( , ) are acceptable, as well as dashes, which are treated as minus signs. You can also click the checkmark in the Formula Bar instead of pressing the [Enter] key to confirm the entry and return to Ready mode. You can force Excel to treat a number as text by typing an apostrophe ( ’ ) as the first character in the cell. The apostrophe appears only on the formula bar; it does not appear within the cell, nor does it print.



P ROCEDURES 1. Select the cell into which you want to enter a number. 2. Type the desired number. 3. Press [Enter] . 4. Enter numbers into additional cells as desired.

Page 48

OFFICEPRO, Inc.