Microsoft® Office Excel® 2007 Plain & Simple

Entering Dates and Times in Cells

Dates are extremely important in any business or personal situation, so Excel takes care to get them right. Excel understands dates no matter how you type them, so feel free to type them as needed. You can always change the formatting later.

Enter a Date

1. Click the cell into which you want to enter a date.

2. Type the month, day, and year, with each number separated by a slash (/) or a hyphen (-).

3. Press Enter.

Enter a Time ...