LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating shortcut keys Magnus Ramfelt via OfficeKB.com Excel Discussion (Misc queries) 1 January 21st 05 01:06 PM
Shortcut to format painter judith Excel Discussion (Misc queries) 2 January 17th 05 04:53 PM
Macro Shortcut Keys Nicolle K. Excel Discussion (Misc queries) 1 January 6th 05 04:55 PM
How to make [toggling] shortcut keys to superscript and subscript, respectively? Mann Lee Excel Discussion (Misc queries) 8 December 13th 04 01:50 PM
Is there a keyboard shortcut for centering data in Excel? Antartica Excel Discussion (Misc queries) 2 November 30th 04 05:30 PM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"