try entering the following formula in B7:
=if(mid(b6,2,1)="9",11,110)+b6
Hope that helps.
- sludge

"cloud" wrote:

The whole question is actually like this:
Create a worksheet that gives in column B a list of all of the 4 digit years
that are palindromes, beginning with 1001 in B6 and extending on down in
ascending order. You may use other columns as well but the final answer for
the row must be in coulmn B. Furthermore,all rows below row 7 must be the
result of filling the cells in row 7 down the worksheet. You may not use Auto
Fill.