Document number: 15167

 

You can enter the current date or time into an Excel spreadsheet cell without having to check your calendar or clock. Follow these steps:

1. Click the cell in which you would like to enter the current date or time.

2. Press one of the following:
   • For the current date: { Ctrl} + { ;}

   • For the current time: { Ctrl} + { Shift} + { ;}

 

The current date or time will be entered. If you wish to use a different format, you must format the cell manually.

 

 

 

 

 

 

Created by the PeopleSoft Knowledge Management Team.
Copyright © 2002 All rights reserved.
Created: kcw 01/28/2003
Reviewed: 01/29/2003