how do i calculate a list of four digit years that are palindromes in Excel?

In A1, enter the number 10.
In A2, enter the formula =A1+1. Fill down to A90.
In B1: =TEXT(A1,"00")&RIGHT(TEXT(A1,"00"),1)&LEFT(TEXT(A1 ,"00"),1)
Fill down.

--
Kind regards,

Niek Otten

"cloud" wrote in message
...
how do i calculate a list of four digit years that are palindromes in
Excel?

Hi,

Use the following formula in any cell and autofill it across 10 columns and
down 9 rows (please don't exceed that range!)

=1001*ROW(A1)+110*(COLUMN(A1)-1)

OR

use the following formula in any cell, substituting "starting row#" with the
actual row number where you are entering the formula, and autofill to reach
"9999" as the result.

=(ROW()+10-starting row#)*100+MOD(ROW()+10-starting
row#,10)*10+QUOTIENT(ROW()+10-starting row#,10)

e.g., if you are entering the formula in any cell in Row 2, the formula
would be,
=(ROW()+10-2)*100+MOD(ROW()+10-2,10)*10+QUOTIENT(ROW()+10-2,10)

Regards,
B. R. Ramachandran

"cloud" wrote:

how do i calculate a list of four digit years that are palindromes in Excel?