Automated Numbers for quote forms

[Emma]

Hi,
I am using Excel 2000. Have created a workbook in the
style of a quote form. I want excel to somehow
automatically create a quote number for me. Can anyone
help?
Emma

 

[Frank Kabel]

Hi Emma
what do you mean with 'quote number'?

 

[Guest]

Hi Frank,

I have created a quote form for a company. Basically when
they open up the form it comes up with a new number each
time. So something like a 6 digit number, but a different
one each time the form is opened.