Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I write the column number as number?

0 views
Skip to first unread message

Kenji

unread,
Oct 8, 2004, 4:48:59 PM10/8/04
to
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


Myrna Larson

unread,
Oct 8, 2004, 5:38:19 PM10/8/04
to
=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

0 new messages