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.