Page 12 of 22PREVNEXT

Audio course: Get to know Excel: Create your first workbook

Numbers aligned on the right side of a 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: Audio course: Get to know Excel: Enter formulas.

Page 12 of 22PREVNEXT