[mso] Re: Excel 2003: Hot key for current time

  • From: "Jim Poston" <poston@xxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Mon, 19 Feb 2007 19:23:44 -0800

On 7 Feb 2007 at 13:09, Andrew wrote:

> In Excel I can use Ctrl+; to enter the current date into a cell but
> this only enters the date (without the time fraction). Is there a hot
> key for entering current date AND time. 

I don't know of a single key for time and date, but Ctrl-Shift-; 
(semicolon) will enter the time, so time and date would be  

Ctrl-;
<space>
Ctrl-Shift-;


-- 
Jim
Poston@xxxxxxxxx

<<      Do I BELIEVE in the Bible?! HELL man, I've SEEN one!!!       >>




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: