You would have to manually convert to a value or use a macro or use
ctrl+colon or shift colon

--
Don Guillett
SalesAid Software

"LaDdIe" wrote in message
...
Hello,

OK, what i want to achive is this;
=IF(A10,NOW())
But!
How do I stop the time re-calculating each time?

Any help welcome