98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pre set date and time
Pre set date and time
Resolved · Low Priority · Version 2003
Tue 20 Jan 2009, 16:55Delegate Rollin said...
Rollin has attended:
Excel Intermediate course
Pre set date and time
how do you fix the date and time that it doesn't automatically update
Thu 22 Jan 2009, 10:32Trainer Amanda said...
RE: pre set date and time
Hi Rollin
Thank you for your question and welcome to the forum.
You can do this by:
1. Entering the =now() function into a cell to give you current date and time.
2. Copy the =now() formula result, and select a different cell.
3. Go to Edit - Paste Special, and choose Values and Number formats, click OK. This will paste the date and time in, but it won't update. You can then delete the =now() function if you wish.
I hope this helps.
Amanda
Wed 28 Jan 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |
