Hi Trevor

OK Thanks for that.

I've managed to work it out using your formula below and adding a code
to read the first three characters of the name of the month in A1.

=LEFT(A$1,3)&TEXT(ROW()-4,"000")

This gives me Jan001 etc all through the workbook and changes the first
three characters according to whatever is in A1. That worked out neatly.


Thanks.

Colin



In article , Trevor Shuttleworth
writes
Try

="Jan" & TEXT(ROW()-4,"000")

Regards

Trevor


"Colin Hayes" wrote in message
...
Hi

I have the name of the month in cell A1 in each of 12 sheets.

From A5 onwards down the page I have the formula

=ROW()-4

which numbers each line. Ideally I would like the numbers to include at
the beginning the first three letters of each month. Each line would then
read Jan001 , Jan002 etc.

Can someone advise how to amend my

=ROW()-4

code to include these characters?

Any help appreciated. Thanks.

Colin