ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i set an auto date function in excel or word? (https://www.excelbanter.com/excel-discussion-misc-queries/14332-how-do-i-set-auto-date-function-excel-word.html)

hpkcommish

how do i set an auto date function in excel or word?
 
I would like all documnts in both word and excel to automatically date as the
document or report is prepared.

Jock W

=NOW()

"hpkcommish" wrote:

I would like all documnts in both word and excel to automatically date as the
document or report is prepared.


peterm

for excell
Go to View Header & footer custom header footer then click on the clock
pic & the date pic (choose 1st if you want it in the left middle or right
feild)
For word basically the same
Cheers peterm

"hpkcommish" wrote:

I would like all documnts in both word and excel to automatically date as the
document or report is prepared.



All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com