1. first enter this tiny User Defined Function:

Function nnow() As Date
nnow = Now
End Function

2. Then In A1 enter 0

3. then, in another cell, say B9, enter:

=nnow()+a1 and format this cell as Custom mm/dd/yyyy hh:mm:ss

B9 will now display like NOW(), but only update when you change the value in
A1.


--
Gary''s Student - gsnu200856