how do I convert column labels back to alphabetic from numeric?

G

Guest

My Excel spreadsheet column labels have mysteriously converted to a numeric
format the same as lines. No idea why, I just want to go back to having them
listed as A, B, C etc. Can anyone help please?

many thanks
 
G

Guest

Click the circular office button on the top left, select "Excel Options"
select the formulas menu and under working with formulas change the "R1C1
reference style" so that it is not ticked.

Hope that helps

Paul
 
G

Guest

In versions 2003 or older, click TOOLS in the menu and select OPTIONS. In
the dialog box click the GENERAL tab and turn of the R1C1 REFERENCE STYLE,
which is the first check box in the SETTINGS panel.
 

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
How do I change excel column heading from numeric to alphabetic? 3
How do change excel columns from alphabetic to numeric 1
Can I change the column heading from alphabetic to numeric? 2
Worksheet Column Labels ... Alphabet or Numeric ? 1
How to change column labels back to letters? 1
how can i convert a number from numeric to alphabetic in excel (e. 2
creating labels from excel spreadsheet 1

Top