• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Date Stamp in a Worksheet?

Texun

Texun

Platinum Member
Using Office 2000, is it possible to have Excel add a date\time stamp to a worksheet so it will appear when printed? I used to do this a long time ago with Quattro Pro but forgot the function, and if Excel has one I am not sure what it would be called. I want to print it to the bottom of the page so I can easily distinguish recent prints from older ones. Any help would be appreciated.

Thanks,

 
Yeah, but doesn't that particular option in the header just insert the date and time of when the worksheet was opened?
 
In Excel XP, if you put &[Date] or &[Time] in for the header or footer, it'll add the current date and/or time to the header/footer of the document when it's printed. I just tried it, and it prints the time the document was printed, not when it was opened. This should do what you need... wouldn't imagine that it'd be too much different in Excel2k


JW
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top