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.