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

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

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

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

"Razorbill" wrote:

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

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

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.
--
Kevin Backmann


"Razorbill" wrote:

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

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

Tools/ Options/ General
Uncheck: R1C1 reference style
--
David Biddulph

"Razorbill" wrote in message
...
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