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.
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.
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.
Search JabSto ::

Custom Search