View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Why not use this

Ctrl-;
press the space bar
Ctrl-:
Enter


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael Link" wrote in message ...
I know Excel provides shortcuts for entering the date (CTRL + ;) and the
time (CTRL + SHIFT + ;), but I really need one that will enter both the date
and time in the same cell at the same time. (Since Excel does provide
formatting for same-cell date and time, it seems kind of odd that there isn't
a shortcut to facilitate entry.) Is it possible to create an entirely new shortcut
that doesn't use macros? (This last point is important, since the workbook is
shared on a network.)

Any help anyone can offer would be much appreciated--I'm getting
desperate. Thanks in advance!