"Dave Peterson" wrote:

Hit and hold the control key
hit the semi-colon key (;)
(you'll see the date entered into the formulabar)
let go of the control key

Hit the space bar

hit and hold the control key
hit the colon key (:)
(you'll see the time added to the formulabar)
let go of the control key

Hit enter to finish.

When you're done, you should see something like:
01/08/2008 09:12:00 AM
in the formulabar

(I use USA date order. Yours may be different.)


Get System Date & Time wrote:

"Gary''s Student" wrote:

Instead of =NOW() use:

CNTRL-; CNTRL-:
--
Gary''s Student - gsnu200764


"Get System Date & Time" wrote:

Sorry I tried "CNTRL-; CNTRL-:" but it does not work. I must have got it wrong. Please elaborate.

--

Dave Peterson

Hi Dave, Thanks I got it to work. Thanks to "gary's Student" as I now
realise what you meant.