View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default Time/Date Stamp: 'control+' not working for me...

Ctrl + ; inserts the date as you said, Ctrl + SHIFT + ; (or in other words
Ctrl + : ) inserts the time so:

Ctrl + ; then <space then Ctrl + : inserts the date and time

--
HTH

Sandy

with @tiscali.co.uk


"lsmft" wrote in
message ...

Now let a true idiot speak.
When I press control & + keys. All I get is the "insert" control box.
When I press control & ; I get the date, but no time.
When I press control & ' I get nothing.
I haven't gotten the "time" yet, even when formatting the cell for time
and date.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=520173