if you format a column date and time, then enter, say 01/06/08 10:30 AM, then
do the VALUE of that cell, you will get a decimal number that represents the
date and time. That could be your reference number.

"Steve C" wrote:

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!