How can I get the system date & time for different cell record
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
|