Fantastic!!! its really working...

But even if it is double digits number needs to be retained 00. But this macro changed as 00R to 001, 002...010. I need to retain two zeros (00) even if the question number is 10.
So it will be changed as 0010, 0011...etc.

thank again for the help....