In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas

- make sure that there is no tick in the box called:-

R1C1 reference style

EXCEL 2003

Tools / Options / General tab €“ remove tick from R1C1 Reference style.

If my comments have helped please hit Yes.

Thanks.



"SalExcel10" wrote:

Somehow I have managed to accidentally change the column references to
numbers rather than letters. How do I get these back? Not sure of the correct
terminology but I am referring to where the rows are usually numbers and the
columns usually letters. My columns are now also numbers!