In an un-used cell format as General and then enter:
=TODAY()
--
Gary's Student


"Alex01" wrote:


Please can someone tell me how to format a cell to show current date
each time a sheet is opened?

thanks in advance


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516232