Unique number

[Guest]

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?

 

[Guest]

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

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

 

[Guest]

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.

 

[Guest]

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.

 

[David Biddulph]

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