Help, my column headings have turned from letters into numbers!

[charry47]

I have no idea how it happened, but every time I open a new Exce
spreadsheet all of my column headings are numbers instead of letters.
How do I turn it back? It's making it very confusing for me to ente
formulas since referring to a cell as "A1", for example, no longe
works.

Thanks

 

[Dav]

go to tools, options, general, is the R1C1 boc ticked? if it is untick
it!

Regards

Dav

 

[dramajuana]

Go to Tools, Click the "General" tab and uncheck "R1C1 reference style"

 

[charry47]

Thank you both very much! I went and unchecked the box and all is back
to normal.