View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Using the =NOW() Function

Yep. You're right.

"Jay Somerset <" wrote:

On Fri, 9 Jun 2006 16:59:34 +0100, "Bob Phillips"
wrote:

Hit Ctrl+colon (:) together, then hit the spacebar, and then
hit-Ctrl-Shift-; (semi-colon) togther, it will show datespacetime.


I think you have the shift key backwarDs on this. The semicolon is the
lower case character -- the colon is the upper case charater. If you use
the shift key, you get the colon.

Therefore, date = cntl-semicolon. Time = cntl-colon = cntl-shift-semicolon.


--

Dave Peterson