Invoice Number

[R2D2]

I created my own invoice using a worksheet since I could not get the invoice
template to do as I wanted. Can someone please tell me how to assign a
changing invoice number cell? Can I make it start with whatever number I
want or must it start with 1?

Thank you in advance, this group has been extremely helpfull.

Gary

 

[Niek Otten]

Hi Gary,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I created my own invoice using a worksheet since I could not get the invoice
| template to do as I wanted. Can someone please tell me how to assign a
| changing invoice number cell? Can I make it start with whatever number I
| want or must it start with 1?
|
| Thank you in advance, this group has been extremely helpfull.
|
| Gary
|
|

 

[R2D2]

thank you very much, just one question tho, what the hell did that page say?
LOL
I was hoping just to have to click Format+cells+ and whatever else needed.
can I just copy and paste the stuff on that web site and copy it
somewhere???