How do I write the column number as number?

K

Kenji

In the Excel formula, I would like to write the column value as a number and
not a letter.

is it possible to do something like "=cells(20, 20)"

Thanks!

Kenjiro Yagi
 
M

Myrna Larson

=INDIRECT(ADDRESS(20,20))

But if you are more comfortable with numeric notation, you could change to
R1C1 notation, in which the formula would be

=R20C20
 
Top