Time Stamp Recalculates with Each Entry

  • Thread starter Thread starter JE McGimpsey
  • Start date Start date
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
 
Back
Top