Column Name Box Question

[Excel-lent]

Hi all, this is my first post!

I've had a search but cannot find an answer to this question. Just recently my columns on all saved Excel files have changed from letters to numbers which has subsequently changed all formulas making it a bit more difficult to work with. (EG instead A1*B1 it now says RC[-2]*RC[-1])

Does anyone know how to change this back, I wasn't aware I had changed any specific option! Thanks in advance for any help.

 

[HaHoBe]

Hi, Excel-lent,

go to Tools / Options General and uncheck R1C1 reference syle.

Ciao,
Holger