Friday, May 31, 2013

Excel Question: print the current time in Excel Cell?


 
Select a cell and hold the CONTROL + SHIFT keys and press colon to insert time.

Use CONTROL + semicolon to insert the date.
--------------------

(If you use the =now() formula in a cell, the present date and time will be inserted - but it will update to the present date/time every time the sheet is recalculated.)

No comments:

Post a Comment