How do I write the column number as number?

  • Thread starter Thread starter Kenji
  • Start date Start date
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
 
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I disable links on the page? 1
File-> Save As -> How Do I Change Default Location? 1
Can Formula Change the Font Color? 2
Changing the image in an imagebox using VBA? 1
Can we add some sort of invisible comment on a cell? 1
In-Cell Drop Down Box getting 0s, help 3
Remove/Ignore Letters when Summing cells in a column. 3
help with formula 1

Back
Top