Columns headings have changed to numbers instead of letters

D

DianeC

All my worksheets now appear with numbers in the column labels. e.g. instead
of a cell reference being A1 it now appears as R1C1. When developing
formulas, the cell reference counts the number of positions I've moved the
cursor. For instance if I move two columns to the right and two rows down it
is referred to as R(2) C(-2) - two postion move backwards from the origninal
column and two rows down. This makes it impossible to identify the cell you
are pointing to in a formula. How do I change the column back to the letter
system?
 

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 are numbers (instead of letters). How to revert? XLS 1
Matching two columns of data 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Columns are numbers instead of letters 4
Newbie question - column letter displayed instead of number 1
Headings of columns now have numbers, need to change them to lette 3
Column headers numbers instead of letters 2
Columns labeled with numbers not letters 9

Top