ExcelBanter - How do I create a formula that continuously numbers my invoices?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I create a formula that continuously numbers my invoices? (https://www.excelbanter.com/excel-worksheet-functions/164372-how-do-i-create-formula-continuously-numbers-my-invoices.html)

Revive-A-Disc

How do I create a formula that continuously numbers my invoices?

Hi,
I was wondering whether anyone knew how to do the following:
How do I create a formula that continuously numbers my invoices, e.g. 001
(first invoice) then when I go to type another invoice it numbers is 002.

PLEASE HELP!

Cheers

Mike H

How do I create a formula that continuously numbers my invoices?

Hi,

A couple of ways here.

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

Mike

"Revive-A-Disc" wrote:

Hi,
I was wondering whether anyone knew how to do the following:
How do I create a formula that continuously numbers my invoices, e.g. 001
(first invoice) then when I go to type another invoice it numbers is 002.

PLEASE HELP!

Cheers

Roger Govier[_3_]

How do I create a formula that continuously numbers my invoices?

Hi

Take a look at J E McGimpsey's solution at
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards
Roger Govier

"Revive-A-Disc" wrote in message
...
Hi,
I was wondering whether anyone knew how to do the following:
How do I create a formula that continuously numbers my invoices, e.g. 001
(first invoice) then when I go to type another invoice it numbers is 002.

PLEASE HELP!

Cheers

All times are GMT +1. The time now is 02:44 AM.