Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set a formula that indicates a if a cell value changed?
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? |
#2
|
|||
|
|||
Use =Today() instead....just returns the date, not the time portion...
Hth, Oj |
#3
|
|||
|
|||
Now function will always return the date and time at the time the sheet
performed calculations. |
#4
|
|||
|
|||
Just enter the date with Ctrl-;
-- HTH RP (remove nothere from the email address if mailing direct) "Zachie" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions |