Tip #3019 - To Update or Not to Update
Printer Friendly Version | E-Mail This Tip
To
Update or Not to Update
Did you know that
there's a choice as to how you insert the date or time into an Excel worksheet?
Did you know that
you could choose to have the date or time entered as a piece of data that
doesn't change or as a field that will be updated when you open the file
or press the F9 key?
Well, as you can guess
by now, you've got a choice and they're more easier to use than you could
ever imagine!
For date and time
data that won't update, use these key combinations:
Ctrl + ;
(semi-colon) to enter today's date in the cell.
Ctrl + Shift
+ : (colon) to enter the current time in the cell.
For date and time
information that updates, try these formulas in the
cells:
=today()
(that's a left and right parentheses with no space) will put today's
date in the cell.
=now()
(that's also a left and right parentheses with no space) will put both
today's date and the current time in the cell.
Now, the only question
is whether to update or not to update. You choose!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
