View Single Post
  #1   Report Post  
Michael Link
 
Posts: n/a
Default Creating a Combined Date/Time Shortcut

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=20
and time in the same cell at the same time. (Since Excel does provide=20
formatting for same-cell date and time, it seems kind of odd that there =
isn't=20
a shortcut to facilitate entry.) Is it possible to create an entirely =
new shortcut=20
that doesn't use macros? (This last point is important, since the =
workbook is=20
shared on a network.)

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