Thread
:
Time/Date Stamp: 'control+' not working for me...
View Single Post
#
9
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
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
Reply With Quote