column display, letters or numbers

  • Thread starter Thread starter bill
  • Start date Start date
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
 
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
column headers changed from letters to numbers, how do I change ba 1
converted spreadsheet to 2007, column letters now numbers?? 2
Columns are numbers instead of letters 4
Columns now numbers rather than letters how do i get letters back 2
Creating sequential numbers plus a letter 4
Cells display as R5C5. How do I change it to display E5? 2

Back
Top