Date and Time

  • Thread starter Thread starter Lord Of The Morning
  • Start date Start date
L

Lord Of The Morning

Is it possible to have a cell show the current date and time without
entering it, like in word?

Nick
 
If you want the current date and time, updated whenever a calculation
occurs, use =NOW(). If you want to enter the current date, without
updating, press CTRL+;
 
How to put a real time clock in a cell??
somebody post a code last month in this news group. but I cannot find.
thanks
 
You must log in or register to reply here.

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

How to enter start and end date/time in excel based on some specific value. 7
Excel Vba to change displayed year automatically. 14
Add on to formula 4
date in excel 16
Can't change the cell back to blank when there is a date in it. 0
Auto Input Today's Date 3
logging date & time of data entry for individual cell 3
Help Needed ... Probably simple for you gurus ... locking cell afterdata entered and 1

Back
Top