Insert the current date and time in Excel - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Insert the current date and time in Excel

Applies to
Microsoft Excel 2000

To insert the current date and time, type =NOW() into a cell. The cell is updated every time the worksheet is recalculated, such as when you open the workbook. The date and time used are taken from your computer's system clock.

To freeze the date

Select the date cell.
On the Edit menu, click Copy.
On the Edit menu, click Paste Special, click Values, and then click OK.

Printer-Friendly Version

Original page: http://office.microsoft.com/en-gb/help/HA010550271033.aspx