Column Headers: Numbers instead of letters

  • Thread starter Thread starter Sabine
  • Start date Start date
S

Sabine

Not quite sure what happened but now the column headers
display as numbers instead of letters and all the formulas
are changed to show formulas in this style=+R6C*RC[1]
instead of referencing letter/number cell references.
 
Thanks alot.
-----Original Message-----
Tools/Options/General. Uncheck the R1C1 References checkbox.

Sabine said:
Not quite sure what happened but now the column headers
display as numbers instead of letters and all the formulas
are changed to show formulas in this style=+R6C*RC[1]
instead of referencing letter/number cell references.
Click to expand...
.
Click to expand...
 

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

Columns labeled with numbers not letters 8
Columns headings have changed to numbers instead of letters 2
Newbie question - column letter displayed instead of number 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
number to character and vice-versa 8
How to switch column headers from numbers back to letters? 2
formula won't change correctly when dragged 4
Excel sort dialog box: Display of column header instead of columnname 1

Back
Top