Thank you for your answer. I never created a macro before. Can you show me
how. Greatly appreciated.

"Gary''s Student" wrote:

=NOW() will update whenever the spreadsheet is calculated. You can insert an
OnTime macro to automatically re-calculate every couple of seconds.
--
Gary''s Student - gsnu200806


"Ted" wrote:

I am using =now() function in cell A1 and frequently press F9 to update to
current time. Is there any way to continuously show the current time running
in the cell A1.