How do I set a formula that indicates a if a cell value changed?

Z

Zachie

I want to use =now() to get the date as a referece but the moment I change
info on the sheet the reference change. How can I keep this reference from
changing?
 
M

Mohamed Shafiee

Now function will always return the date and time at the time the sheet
performed calculations.
 
B

Bob Phillips

Just enter the date with Ctrl-;

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top