I need create an worksheet as following by using macro, the cell only 6
numeric number like this
000002
002002
004002
006002
.....
998002
first and second character is 0,the 3rd character need to increment by 2 for
each row, the 5th and 6th character is 0, the sixth character is 2 all the
way to the end, the last row will be 998002.
did any one how to do this in excel macro?

thank you so much