I have 2 columns in this worksheet that I need help with. I am trying to set
it up where when a value is entered into column A, the date & time will
automatically fill in column B. Here's the formula I'm using
=IF(A1="","",Now()). However, I need for the date/time info to remain
constant. Is there anyway to make Now() a non-volatile function?