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.
onyourmarkAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.