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

R

Razorbill

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
 
P

Paul Mugleston

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
 
K

Kevin B

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 to add a letter to front of column sample ID 2
numerical columns 8
How do change excel columns from alphabetic to numeric 1
Worksheet Column Labels ... Alphabet or Numeric ? 1
How do I change excel column heading from numeric to alphabetic? 2
Having Blank Cells, etc. ? 1
Help with an Excel formula please? 7

Top