Microsoft Office Tutorials and References
In Depth Information
Entering dates and times in cells
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 in 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.
1
2
Enter a time
1 Click the cell in which you want to enter a time.
2 Type the hour, a colon (:), and the minutes. Press the spacebar, and
type a or p for A.M. or P.M.
3 Press Enter.
1
2
CAUTIoN Your regional settings affect which entries Excel
interprets as dates. In countries that represent dates using the
Day/Month/Year format, 9/25/2013 would be interpreted as a text
entry because there are only 12 months in a year.
Search JabSto ::




Custom Search