column display, letters or numbers

B

bill

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
 
B

Bernard Liengme

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
 

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel Column labels show as numbers 2
converted spreadsheet to 2007, column letters now numbers?? 2
Columns are numbers instead of letters 4
column headers changed from letters to numbers, how do I change ba 1
Cells display as R5C5. How do I change it to display E5? 2
Creating sequential numbers plus a letter 4
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3

Top