Entering Numbers and Dates

Contact Us or call 1-877-932-8228
Entering Numbers and Dates

Entering Numbers and Dates

In the next lesson we will cover formatting numbers to include commas, decimals, currency symbols and more, and formatting dates in various ways. In this lesson, however, we will simply enter dates and numbers in the most basic format, and use autofill to quickly add numbers that follow a pattern.

To enter numbers in Microsoft Excel:

  1. Select the cell into which you wish to enter a number by clicking on it.
  2. Begin typing a number.

Things to be aware of when entering numbers:

  1. There is no need to enter commas. If you wish to display commas, you can format your numbers to display them. This will be covered in the next lesson.
  2. By default, trailing zeroes are not shown. For example, if you enter "5.00" into a cell and press Enter, the value shown will change to just "5". We will cover displaying decimals in the next lesson.

To enter dates in Microsoft Excel:

  1. Select the cell into which you wish to enter a date by clicking on it.
  2. Type the date in the following format: mm/dd/yy (e.g., 12/21/12) or m/d/yy (e.g., 1/1/00).
Next