Incrementing Requirement ID

[cmartin765]

I need to increment sr[01], sr[02], etc.. in an excel column how would i do that?

Thanks!

 

[BobUmlas]

Format the column as:
"sr["00"]"
and just enter the number 1 and put 2 in the cell below. Select both and use the fillhandle.

 

[Scott Huish]

=TEXT(ROWS($A$1:A1),"\s\r\[00\]")

Copy down.