Entering Numbers

Data that serves as the values in your workbooks can include the numeric characters 09. Because formulas are also considered values (you learn about simple calculations in Lesson 3), other valid value characters include symbols such as +, , /, and *. You can also use characters such as a comma (,), a percent sign (%), or a dollar sign ($) in your values. You will find, however, that you can save yourself a few data-entry keystrokes and add these characters using different Excel formatting options (you learn about Excel formatting in Lesson 9, "Changing How Numbers and Text Look").

For example, you could enter the dollar amount $700.00 including the dollar sign and the decimal point. However, it's probably faster to enter the 700 into the cell and then format all the cells that contain dollar amounts after you have entered all the data.

To enter a value, follow these steps:

  1. Click in the cell where you want to enter the value.

  2. Type the value. To enter a negative number, precede it with a minus sign or surround it with parentheses.

  3. Press Enter or the Tab key; the value appears in the cell right-aligned. Figure 2.4 shows various values entered into a simple worksheet.

    Figure 2.4. Values are right-aligned in a cell.



What Are All Those Pound Signs? If you enter a number and it appears in the cell as all pound signs (#######) or in scientific notation (such as 7.78E+06), the cell just isn't wide enough to display the entire number. To fix it, double-click the right border of the column's heading. The column expands to fit the largest entry in that column. See Lesson 12 for more information on working with column widths.

Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
Year: 2002
Pages: 660
Authors: Joe Habraken

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net