how to make sesquential invoice numbers
 

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?

how to make sesquential invoice numbers
 

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?

how to make sesquential invoice numbers
 

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?

how to make sesquential invoice numbers
 

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?

how to make sesquential invoice numbers
 

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?

how to make sesquential invoice numbers
 

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

how to make sesquential invoice numbers
 

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

"MartinW" wrote:

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