My Excel cols have #s, not letters. How get letters?

[connie in maryland]

Sometimes our excel docs have their columns mysteriously switched from a
letter heading to a # (and rows are numbered) so that formulas cannot be
done. This "column numbering" seems to be contagious. If you have another
excel doc open, its cols switch from letter headings to #s. Any ideas? Thanks!

 

[Dave F]

YOu have R1C1 references checked in your options.

Go to Tools--Options--View and uncheck R1C1 reference.

 

[connie in maryland]

Thanks Dave -- in my version it was Tools / Options / General and turning off
R1C1 fixed it. I am not so brief.

 

[Dave F]

I think the path you give is the correct one for all versions. My mistake,
sorry.