View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Richard
 
Posts: n/a
Default Current date and time updated automatically

=now() is not automatic now is it

"Nikki" wrote:

=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.