ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column display, letters or numbers (https://www.excelbanter.com/excel-discussion-misc-queries/190538-column-display-letters-numbers.html)

Bill

column display, letters or numbers
 
I am using excel 2007, i found an answer but in an earlier version of excel
Some how my column identifier changed from letters to numbers and i dont know
how to change it back

Bernard Liengme

column display, letters or numbers
 
Office button (colourful circle in top left)
Excel options (at bottom of dialog)
Formula tab (second item in left panel)
Uncheck the box "R1C1 reference style" (first item in "Working with
formulas")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"bill" wrote in message
...
I am using excel 2007, i found an answer but in an earlier version of excel
Some how my column identifier changed from letters to numbers and i dont
know
how to change it back





All times are GMT +1. The time now is 12:29 PM.

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