Thread: Unique number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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?