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

I have no idea how it happened, but every time I open a new Excel 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 enter formulas since referring to a cell as "A1", for example, no longer works.

Thanks!

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

Regards

Dav

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

"charry47" wrote:

>
> I have no idea how it happened, but every time I open a new Excel
> 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 enter
> formulas since referring to a cell as "A1", for example, no longer
> works.
>
> Thanks!
>
>
> --
> charry47
> ------------------------------------------------------------------------
> charry47's Profile: http://www.excelforum.com/member.php...o&userid=36636
> View this thread: http://www.excelforum.com/showthread...hreadid=563864
>
>

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