ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column labels have changed to numbers (https://www.excelbanter.com/excel-discussion-misc-queries/66482-column-labels-have-changed-numbers.html)

Ken Knott

column labels have changed to numbers
 
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.

CLR

column labels have changed to numbers
 
Tools Options GeneralTab uncheck R1C1 reference style

Vaya con Dios,
Chuck, CABGx3


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



Ken Knott

column labels have changed to numbers
 
Brilliant! Thanks.

"CLR" wrote:

Tools Options GeneralTab uncheck R1C1 reference style

Vaya con Dios,
Chuck, CABGx3


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





All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com