Monday, December 12, 2011

In Excel, how do you make the current date show up in a certain spot each time you open that workbook?

We have a certain invoice template that always used to put the current date on the page, but had to change it once, and ever since, I've had to type in the date instead of it automatically putting it there. HELP!|||Select the cell and go to Insert -%26gt; Function


then select All from the combo box and type "Today" in the top field, then click on Go


Finally select "Today" from the list and click OK. You're done!


Good Luck!|||=NOW() and format the cell as a date.

No comments:

Post a Comment