Hi
you have to use an event procedure for this. See:
http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany

"antho10359" schrieb im
Newsbeitrag ...
I am trying to find a way to create a unique serial number based upon
the
current julian date + an increment counter.

I have sort of done this however the julian date function is not
static and
all the serial numbers change each day. I need to create be able to
create
the serial number (maybe by clicking on a cell) and then once the
number
populates the cell, it remains fixed.

Any suggested would be welcome.