Is there a way so that when my sheet is opened up the first time NOW will put
in the correct date in one cell and the time in another but when it is open
again the time wont change.

The sheet we use is sent to an individual and they inturn open it, copy and
paste rows to a master sheet they have (they wont use ACCESS which I think
would be easier). The sheet we send we do not keep so we have the sheet as an
XLT (2003 is our version) so someone doesn't accidently save and mess up our
master copy.

Column "A" is date sent, Column "B" is time sent (I know this is shown in
the email but this is a goverment office we send to so they make it as
difficult as possible I think. My sheet has 20 rows with a possibility of 20
dates and time in columns A and B but we will more than likely have no more
than 6. Any suggestions would help.