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

[Guest]

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?

 

[oferns]

Use =Today() instead....just returns the date, not the time portion...
Hth,
Oj

 

[Mohamed Shafiee]

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

 

[Bob Phillips]

Just enter the date with Ctrl-;

--

HTH

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