Thread: Current date and time updated automatically
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default Current date and time updated automatically
=now()

"Richard" wrote:

Is there a way to have the date and time in cell g2 to constantly show the
currect time and date every second. Like a watch with a second hand.
Reply With QuoteReply With Quote