Copy the cell
Edit paste-special, values back into the same cell
that fixes the values

What you can do is set up a simple macro that will do this action for you
(copy - pastespecial values) on the range that you define (I am imagining a
column).

You can then have a button to run this macro (edittoolbarsforms, and drag
in a button)

does that help?
--
Allllen


"jonathandr" wrote:

Basically i want to have the date & time populate a cell automatically when
another cell has a barcode scanned into it, that is no problem but when the
time passes to another minute and another barcode is entered it changes every
date & time in the sheet! i want them to stay static once they are in the
sheet.

Can anyone help???