Hi

OK Thanks - that's got it!

^_^

Colin


In article ,
?B?RWxrYXI=?= writes
Try this:

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

HTH,
Elkar

"Colin Hayes" wrote:

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






Are you aware that we also buy CDs, Vinyl and DVDs? Send your lists of
unwanted items to and well quote you a price€¦


You can browse and buy direct from my full list of items at these addresses :

http://s1.amazon.co.uk/exec/varzea/t.../026-3393902-9
050050

or:

http://www.CDandVinyl.co.uk

or :

http://www.netsoundsmusic.com/chayes

or:

http://chayes.musicstack.com



To DOWNLOAD the full catalogue click here :


http://www.chayes.demon.co.uk/chayes_full_catalogue.exe



Best Wishes ,

Colin Hayes.



TEL / FAX : (UK) (0)208 804 9181