Why not just get the Julian date, append a 1 to it and manually add 1 every
time you use it? For example, using Chip's formula, 1/6/2008 is 08006. You
copy that and paste special/value into a cell so that you have a number not
a formula and append 1 to make it 080061 (or 0800601, 08006001 etc). Each
time you use the number, you increment it by 1 manually, and so after using
080061, it becomes 080062 for the next use. The problem with formulas
involving date and time functions is that they are volatile - that is they
change every time anything is calculated on the worksheet. It sounds to me
like you want numbers that change only when you use them.

tyro

"Steve C" <Steve wrote in message
...
I am trying to create a spreadsheet to log some drawings that are done. I
would also like to use the julian date as a reference number. I have tried
to
use the function found here, http://www.cpearson.com/excel/jdates.htm, but
that doesn't give me enough detail. Since I need multiple reference
numbers
during the day, that function, which only gives me the year and the day,
limits my numbering scheme.

Can anyone help?

Thanks in advance!