This is what I have in column A:

=IF(B11="", "", NOW())

Can those key strokes replace "NOW()" ? I want it so that when the operator
enters a value in column B, a static date and time automatically appear in
column A. Is this possible?

Thanks.

"Gary''s Student" wrote:

A very tiny trick:

First click in the formula bar and then touch:

CNTRL-;
spacebar
CNTRL-SHFT-;
ENTER

This will enter the date followed by a space followed by the time in the cell
--
Gary''s Student - gsnu200807


"bflorox" wrote:

I have a 2-column ss that returns the current date and time in one column
when an entry is made in the neighboring column. I want the dates and times
to be static, meaning, I want those values to stay what they were when the
entry was made instead of all changing to the current date and time whenever
a new entry is made.