Time Stamp Recalculates with Each Entry

[JE McGimpsey]

See

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

 

[ajocius]

I'm using a barcode scanner to input data into Excel. The following is used
to create my timestamp. Unfortunately, each time I scan, all the previous
entries scan with the most recent scan. In other words, if I have 10 scans,
they all have the same date. How do I ensure that once I scan, its
timestamp doesn't change. See below:

=IF(ISBLANK($I$17),"",NOW())

Tony