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."
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.
For information about applying number formatting such as dollar and percent signs instead of typing them, see "Formatting Cells Containing Numbers".
3.16.79.65