Re: Use Julian Date To Create Serial Number
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/08/04
- Next message: Frank Kabel: "Re: How do I change row height to 16.0? I get choice of 15.6 (26 Pix."
- Previous message: John Mansfield: "Re: Identifying the Active Fill Color"
- In reply to: antho10359: "Use Julian Date To Create Serial Number"
- Next in thread: Ron Rosenfeld: "Re: Use Julian Date To Create Serial Number"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 8 Dec 2004 23:24:44 +0100
Hi
you have to use an event procedure for this. See:
http://www.mcgimpsey.com/excel/timestamp.html
-- Regards Frank Kabel Frankfurt, Germany "antho10359" <antho10359@discussions.microsoft.com> schrieb im Newsbeitrag news:A9F2F642-D647-470E-858B-463FE23334F5@microsoft.com... > 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.
- Next message: Frank Kabel: "Re: How do I change row height to 16.0? I get choice of 15.6 (26 Pix."
- Previous message: John Mansfield: "Re: Identifying the Active Fill Color"
- In reply to: antho10359: "Use Julian Date To Create Serial Number"
- Next in thread: Ron Rosenfeld: "Re: Use Julian Date To Create Serial Number"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
