how to make sesquential invoice numbers

[chrisbmo2000]

I am using the =rand formula for my invoice #s is there a formula to do this
in a numerical order and not change everytime a change is made?

 

[Norman Jones]

Hi Chris,

I find the idea of using a random number
function to generate invoice numbers
intriguing and certainly not intuitive.

See, however, J.E. McGimpsey's
suggestions at:

Using sequential numbers
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

 

[MartinW]

Intriguing to say the least, the mind boggles at how
the filing system works.<g>

Regards
Martin

 

[Norman Jones]

Hi Martin,

Intriguing to say the least, the mind boggles at how
the filing system works.<g>

I have seen many (apparently) random filing
systems! <g>

 

[chrisbmo2000]

it was the only function that i could readly find to make numbers but it is
very inconsistant
thanks for your help
chris

 

[MartinW]

Hi Chris,

Sounds like Norman's tip has helped your problem.
Please don't be offended by my flippant remark,
your use of rand() is just a little unusual.<g>

Sincerely
Martin

 

[chrisbmo2000]

no problem im still trying to figure out how to do it so we will see