Here is a better solution than the one I suggested earlier.

Try =CONCATENATE("Row ", ROW(), " ", TEXT(ROW(),"0000"))

then you can copy the row and Paste Special/value over itself to remove
all of the functions so it doesn't stay linked to the row number. It's just
text at that point.

hope this helps

"dhstein" wrote:

Hi - I need a formula that will generate text strings in rows like

row 1 0001
row 2 0002
row 3 0003
.
.
.
row 9999 9999

I want the leading zeros and I can't figure out what value to use in the
Text formula to get that to work. Thanks for your help.