=now()
format as date and time.

This will update whenever excel recalculates.

Alex01 wrote:

Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex

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

--

Dave Peterson