Function NOW
Thanks for the answer
Where can I define my own functions?
//Peter
"Gary''s Student" wrote:
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
|