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

"Norman Jones" wrote:

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




---
Regards.
Norman

"MartinW" wrote in message
...
Intriguing to say the least, the mind boggles at how
the filing system works.<g

Regards
Martin


"Norman Jones" wrote in message
...
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


---
Regards.
Norman


"chrisbmo2000" wrote in message
...
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?