Time Stamp Recalculates with Each Entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ajocius - 09 Dec 2007 05:53 GMT

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

Reply to this Message

JE McGimpsey - 09 Dec 2007 07:03 GMT

See

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

> 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
[quoted text clipped - 5 lines]
>
> Tony

Reply to this Message