So if you change something in column A (say), you want the date/time in column
X???

If yes, you may want to look at how JE McGimpsey does it:
http://www.mcgimpsey.com/excel/timestamp.html

Guard823 wrote:

Is there any way to make Excel timestamp a cell without it updating to the
current time when saved? This function will be used up to hundreds of times
a day for logged entries on a computer.

--

Dave Peterson