Hi,

Several techniques here

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

Mike

"gigglygover" wrote:

I want to set up a template that when opened in one cell will give me #1 the
first time it was used, then #2 the second time. I want the numbers to be
incremental in 1's,

Any suggestions please