Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
wise ass who changed column headers to numbers instead of letter | Excel Discussion (Misc queries) | |||
Can the preset numbers in the column be changed? | Excel Discussion (Misc queries) | |||
restoring column labels Excel 2002 | Excel Discussion (Misc queries) | |||
Average of numbers in column between to other numbers | Excel Discussion (Misc queries) |