Hi,
Thanks for the prompt response. I have given it a try and it does work but
I still have to change the + no. to get it to move on a number each time. I
have to set up 150 receipts so that way would take alot of time. If you have
another idea I'm all ears.
Thanks
Sue

"JE McGimpsey" wrote:

One way:

O1: =LEFT(G1,3) & TEXT(RIGHT(G1,3)+1,"000")
G21: =LEFT(G1,3) & TEXT(RIGHT(G1,3)+2,"000")

Copy O1 to O21, O41, etc. Copy G21 to G41, etc.



In article ,
Sue wrote:

I am doing a receipt template under excel where it automatically updates info
from various workbooks giving the period payments made and then totals it and
converts the total to words. My question is how do I get it to automatically
put the sequential receipt number's into non adjacent cells e.g.
first receipt no. is 06/001 in cell G1, 06/002 is to be in cell O1, 06/003
cell G21, 06/004 cell O21, 06/005 cell G41, 06/006 cell O41... Don't want to
do it manually.
I'm just a novice, so I'm hoping someone has a simple answer.