Project

If you are doing any formulas or VBA programming in excel, you probably know about the now() function which returns the current date and time. The problem with Now() is that it is always changing so often it is easier to simply enter the date you want to use. I used to just use the formula =now() and then cut and paste special.

Fortunately there is a simple keyboard shortcut for doing this which you can use to insert the date and time anywhere you want (even within text).

To insert the current date hold down the CTRL key and then type a semicolon ; (CTRL+;)
To insert the current time hold down the CTRL key and then type a colon : (CTRL+Shift+:)

The correct date and time values will be inserted in the cell you are typing in.