Thread: Unique number
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?