software

How can I get an automatic number whenever I open the spreadsheet(form)? For
example, I have a form using excel. When I open the form, it will give me a
new number. Let say, 100. When I close and open it next day or next time,
it will give me a number 101.

Can anyone help me? thanks.


quot;momotaroquot; gt; wrote in message
...
gt; How can I get an automatic number whenever I open the spreadsheet(form)?
gt; For
gt; example, I have a form using excel. When I open the form, it will give me
gt; a
gt; new number. Let say, 100. When I close and open it next day or next
gt; time,
gt; it will give me a number 101.
gt;
gt; Can anyone help me? thanks.

Someone posted this link last week, for a similar question:

www.mcgimpsey.com/excel/udfs/sequentialnums.html