=NOW() will recalculate, but what john is doing dose not put in a formula
it puts in the date and time so it will not recalculate
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"JLGWhiz" wrote in message
...
Be aware that the Now() will recalculate each time you open the file
whether
there is a change or not.

"CDDAH NHS" wrote:

Excellent, thanks John!