- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

To Update or Not to Update

Posted By On October 13, 2006 @ 2:15 PM In MS Excel,MS Office Help | Comments Disabled

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

To Update Or Not To Update

Posted By On November 17, 2004 @ 3:13 PM In MS Excel | No Comments

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 easier than you could imagine to use.

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.


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/to-update-or-not-to-update/