column labels have changed to numbers

G

Guest

Strangely the column labels in my excel files have changed from letters to
numbers. I did not do anything intentionally to bring about this change!
The rows are also still labelled by numbers so building formulae will be
difficult!
Does anyone know why this has happened and how i can put it right? Thanks.
 
C

CLR

Tools > Options > GeneralTab > uncheck R1C1 reference style

Vaya con Dios,
Chuck, CABGx3


Ken Knott said:
Strangely the column labels in my excel files have changed from letters to
numbers. I did not do anything intentionally to bring about this change!
The rows are also still labelled by numbers so building formulae will be
difficult!
Does anyone know why this has happened and how i can put it right?
Click to expand...
Thanks.
 

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

column labels 2
How to change column labels back to letters? 1
Column labels 4
why have my column headings changed to numbers 1
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
column changed to numbers 2
converted spreadsheet to 2007, column letters now numbers?? 2
Column Labels 3

Top