Excel static current date/time problem

G

Guest

To insert static current date and time Ctrl+ and Shift+ are supposed to work.
They have no effect when I use them. I'm using an IBM laptop.

Is there another way to put in a static date and time?
 
T

Trevor Shuttleworth

You may have missed a character

ctrl+colon for time (or ctrl+shift+semicolon)
ctrl+semicolon for date

regards

Trevor
 

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

Insert date, but keep static on archived 4
Keyboard shortcut for current date and time 1
Current Date/Time 3
? enter a static time (Excel) in a cell using the IF function 2
static "now" values 5
Formatting a row to insert current date and time on demand 1
Excel: How to insert current time (static) to the nearest second? 14
how can i set a static date and time in excel 2

Top