Unique number
 

I've tried everthing on this issue. I flunked computer 101 for dummies. Is
there somebody who can help me? I want a unique number for a spreadsheet in
excell each time I open it. Can I mail you the spreadsheet?

Unique number
 

put:
=NOW() in a cell and format the cell as General.

Since time never goes backward, the value you see will never repeat!!
--
Gary''s Student - gsnu200736


"bvr" wrote:

I've tried everthing on this issue. I flunked computer 101 for dummies. Is
there somebody who can help me? I want a unique number for a spreadsheet in
excell each time I open it. Can I mail you the spreadsheet?

Unique number
 

I can see it now, just like y2k, time does not move backwards, but the system
clock does one hour once per year. Just a little early morning teasing.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Gary''s Student" wrote:

put:
=NOW() in a cell and format the cell as General.

Since time never goes backward, the value you see will never repeat!!
--
Gary''s Student - gsnu200736


"bvr" wrote:

I've tried everthing on this issue. I flunked computer 101 for dummies. Is
there somebody who can help me? I want a unique number for a spreadsheet in
excell each time I open it. Can I mail you the spreadsheet?

Unique number
 

Actually John, your little tease revealed a true problem with my answer. It
is possible to get a non-unique value if the file is opened during the Fall
Daylight Savings Time transition.
--
Gary''s Student - gsnu200736


"John Bundy" wrote:

I can see it now, just like y2k, time does not move backwards, but the system
clock does one hour once per year. Just a little early morning teasing.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Gary''s Student" wrote:

put:
=NOW() in a cell and format the cell as General.

Since time never goes backward, the value you see will never repeat!!
--
Gary''s Student - gsnu200736


"bvr" wrote:

I've tried everthing on this issue. I flunked computer 101 for dummies. Is
there somebody who can help me? I want a unique number for a spreadsheet in
excell each time I open it. Can I mail you the spreadsheet?

Unique number
 

.... but you'd have to be pretty unlucky to get the same time to a fraction
of a second.
--
David Biddulph

"Gary''s Student" wrote in message
...
Actually John, your little tease revealed a true problem with my answer.
It
is possible to get a non-unique value if the file is opened during the
Fall
Daylight Savings Time transition.

"John Bundy" wrote:

I can see it now, just like y2k, time does not move backwards, but the
system
clock does one hour once per year. Just a little early morning teasing.

"Gary''s Student" wrote:

put:
=NOW() in a cell and format the cell as General.

Since time never goes backward, the value you see will never repeat!!

"bvr" wrote:

I've tried everthing on this issue. I flunked computer 101 for
dummies. Is
there somebody who can help me? I want a unique number for a
spreadsheet in
excell each time I open it. Can I mail you the spreadsheet?