Microsoft Office Tutorials and References

In Depth Information

**Entering numbers in cells**

Entering numbers in cells

The backbone of any workbook is the numerical data in its

worksheets, whether that data reflects sales, employee salaries,

or the quantity of a given product that you have in inventory.

Entering numbers in Excel is as simple as clicking the cell and

typing, but you can also enter very large or very small numbers

using scientific notation. In scientific notation, a number with

a positive exponent is written as 1.00E+06, which is read as

“one times ten to the sixth power.” Numbers that are less than

one can be written with negative exponents. For example, the

number .001 would be written as 1.00E-03 and read as “one

times ten to the negative third power.”

Enter numbers

1
Click the cell in which you want to enter a number.

2
Type a numerical value.

3
Press Enter.

1

2

Enter numbers using scientific notation

and exponents

1
Click the cell in which you want to enter a number.

2
Type the base number you want.

3
Type
E
.

4
Type the exponent you want.

5
Press Enter.

1

2 3 4

TIP You can type a number but have it interpreted as a text

value by typing ‘ (an apostrophe) before the number value. The

apostrophe will not appear in the cell, but a green icon will appear in

the corner of the cell; clicking the cell exposes formatting options you

can apply to the data.

SEE ALSo For information about applying number formatting

such as dollar and percent signs instead of typing them, see

“Formatting cells containing numbers” on page 126.