cell to return current date?

J

jwcater

How do I get a cell to return the current date in Excel 2000? I want a
particular spreadsheet to display the current date in a field each time
I open that particular file. Can this be done in Excel 2000?

Thanks,
John
 
B

Bob Phillips

John,

Just use this formula

=TODAY()

and format as a date.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top