I don't see how Access would help you. Excel is much better suited for
generating unique numbers. If you only need a few, it's hardly worth going
to great lengths to get them. Sometimes manual is better. :) You could also
make a macro to update your number by one so that you have only to press a
hot key.

tyro

"Steve C" wrote in message
...
That's also a thought. What I was trying to do is create a way to hand out
drawing numbers. I know I should probably be using Access, but I'm not
familiar with that at all, and thought I could give it a go in Excel.

Obviously I'm not a whiz kid in Excel either, but at least I'm familiar
with
it, and "ain't skeered". ;-)

Thanks!



"Tyro" wrote:

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!