Improve company productivity with a Business Account.Sign Up

x
?
Solved

change column letters to numbers in 2010

Posted on 2011-09-09
3
Medium Priority
?
3,005 Views
Last Modified: 2012-05-12
I heard there is a way to change column letters to numbers in Excel 2010. Does anyone know how to?
Thanks.
0
Comment
Question by:onyourmark
3 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 36509913
On the Ribbon, choose File.  Click Options, and in the options form choose Formulas.  Check the box for R1C1 reference style.
0
 
LVL 81

Expert Comment

by:byundt
ID: 36510084
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
 

Author Closing Comment

by:onyourmark
ID: 36514796
Thanks all.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This article presents several of my favorite code snippets.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question