Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3001
  • Last Modified:

change column letters to numbers in 2010

I heard there is a way to change column letters to numbers in Excel 2010. Does anyone know how to?
Thanks.
0
onyourmark
Asked:
onyourmark
1 Solution
 
Patrick MatthewsCommented:
On the Ribbon, choose File.  Click Options, and in the options form choose Formulas.  Check the box for R1C1 reference style.
0
 
byundtCommented:
The practical benefit of changing the column letters to numbers is when you need to figure out column offsets for VLOOKUP, INDEX or OFFSET formulas or when you put a formula in cells in VBA using the FormulaR1C1 property of a range. I do it for this reason about once a week.

If instead you want to play a prank on a coworker, you might also want to try the right to left setting as well. This is found in File...Options...Advanced dialog in the Display Options section.
0
 
onyourmarkAuthor Commented:
Thanks all.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now