Unique number

B

bvr

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?
 
G

Gary''s Student

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

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

John Bundy

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.
 
G

Gary''s Student

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.
 
D

David Biddulph

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