Hi all.
First ever forum ive joined so please take it easy on me haha

I work for a small family run business and I would like to use excel for creating purchase orders for our suppliers. I have already got the infield staff using excel for conducting service reports but I am stuck on having a way to auto generate purchase order numbers starting from 1000 then 1001, 1002 etc etc.

I am using excel 2013 but would like it to be compatible with other versions of excel (down to 2003) if possible.

I only have basic knowledge on excel but what I am loving learning how to utilize excel for small business

Please help.