Date/time code, both, accesible by one keystroke?

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

I've been using the ^+; a lot in my spreadsheets ever since I learned about
them in this ng a few weeks back. I custom format the cells, too.

This has worked extremely well. But is there a way to have both the current
date _and_ time keyed in with _one_ keystroke in one cell, with the right
formatting of course, rather using the ^+; for the date and then in another
cell, CTRL+SHIFT+: for the time? It would be nice to save the user
time/aggravation by just using one cell and one hotkey-type of function.

Thank you!
 
B

Bob Phillips

see my reply in .programming

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date/time code, both, accesible by hotkey? 4
needing a keystroke for the current date AND time 3
Date/Time issue with Pivot Table 3
Creating a Combined Date/Time Shortcut 7
How do I enter dates with one keystroke 2
insert time 2
date and time separation 2
Date/Time stamp with one stroke? 10

Top