Hi Max and Fred. I was taking the question too literally. I was trying to
generate the whole thing .... Row 5 0005 , not just the 0005 .

Sorry if I confused the issue. Fred's earlier solution gave me something to
use to build a function for the whole thing that I posted a moment ago.

cheers,

"Max" wrote:

=Text(row(),"0000")
That didn't work for me

I'm quizzical. Fred's suggestion works ok for me, and it should for you,
too, as long as its placed in any cell in row1, then copied down from there
(since ROW() is sensitive to the row it is placed in).

What exactly did the expression return for you?

For increased flexibility to start with 0001 in any cell, just apply a small
tweak
In any starting cell, say, in B3: =TEXT(ROWS($1:1),"0000")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---