Sorry, meant to post to "Worksheet Functions". ? has been answered there.

Thanks.

"bflorox" wrote:

date and time are from @now, not @today. I don't want those values to change
every time I make an entry.

"bflorox" wrote:

I have a 2-column ss. One column is a value and the other is the current
date and time the value was entered. I have set the date and time to appear
only if a value is entered in the neighboring column. I want the date and
time to always be there as the date and time it was when it was created. How
can I pin that value so they don't change every time I open up the ss?
Thanks.