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?

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Brad W" <Brad wrote in message ...
|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?

Sweet, appreciate the help

"Niek Otten" wrote:

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Brad W" <Brad wrote in message ...
|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?