how can i set a static date and time in excel

G

Guest

The help function says to do this: Current date and time Select a cell and
press CTRL+; then SPACE then CTRL+SHIFT+;

I do CTRL+ and i get the 'insert' window and can go no further. What am i
doing wrong?
 
G

Guest

The HELP file is mis-leadng you. When it says:

press CTRL+;

it really means press the CNTRL key and the ; key at the same time


The + really means at the same time.
 

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

Keyboard shortcut for current date and time 1
Insert date, but keep static on archived 4
Formatting a row to insert current date and time on demand 1
Excel static current date/time problem 1
? enter a static time (Excel) in a cell using the IF function 2
Automate date & time entry 1
Learning arrays. 13
Excel: How to insert current time (static) to the nearest second? 14

Top