Try:

=Text(row(),"0000")

Regards,
Fred.

"dhstein" wrote in message
...
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.