Page 13 of 23PREVNEXT

Get to know Excel 2007: Create your first workbook

Numbers aligned on right side of cell

Excel aligns numbers on the right side of cells.

To enter the sales amounts in column C, the Amount column, you would type the dollar sign ($), followed by the amount.

Other numbers and how to enter them

  • To enter fractions, leave a space between the whole number and the fraction. For example, 1 1/8.
  • To enter a fraction only, enter a zero first. For example, 0 1/4. If you enter 1/4 without the zero, Excel will interpret the number as a date, January 4.
  • If you type (100) to indicate a negative number by parentheses, Excel will display the number as -100.

If you want to know how to add, divide, multiply, and subtract numbers in Excel by using formulas, you need this course: Get to know Excel 2007: Enter formulas.

Page 13 of 23PREVNEXT