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 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 into which you want to enter a number.

  2. Type ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.