98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Excel Intermediate
excel training in uk - Excel Intermediate
Resolved · Low Priority · Version Standard
RE: Excel Intermediate
Hi sarah,
If you type in the formula =today() this will return the current system date. This will automatically update on a daily basis. So today it would say 21st November. If I went back to it tomorrow the it would say 22nd of November etc.
If you wanted to insert today's date and then have that remain the same, perhaps as some sort of time stamp then you would need to first copy the cell with the formula in it. You could then select the same cell and click on edit-Paste special and choose the value option. This would replace the formula with the actual date and this wouldn't subsequently change.
Regards
Stephen
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:Convert a column into row quickly in Excel 2010Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa. |