Can I change the column heading from alphabetic to numeric?

  • Thread starter Thread starter Lunchbox18
  • Start date Start date
L

Lunchbox18

I want to reference cells in a R1C1 format instead of A1. The heading diplay
of the columns should be numeric instead of alphabetic.
 
In Excel 2003 or earlier versions:

Go to TOOLS, then OPTIONS
Select the GENERAL Tab
Check "R1C1 reference style" checkbox
Click OK

In Excel 2007:

Click the Office Button (big circle in upper-left)
Click on the EXCEL OPTIONS button
Select the FORMULAS Tab on the left
Check "R1C1 reference style" checkbox
Click OK

HTH
Elkar
 
1. from the menu bar select tools>options
2. select general tab
3. put a check mark on the R1C1 Reference style
4. click OK


Chris
 
You must log in or register to reply here.

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: reset the column headings from numeric to alphabetic? 1
Why are my column headings numerical instead of alphabetical? 1
How do I change excel column heading from numeric to alphabetic? 3
alter column ref 3
Column headings to numbers and row headings to alphabets? 2
Alpha to Numeral column name 3
How do change excel columns from alphabetic to numeric 1
Column Reference 2

Back
Top