I think the path you give is the correct one for all versions. My mistake,
sorry.
--
Brevity is the soul of wit.


"connie in maryland" wrote:

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

"Dave F" wrote:

YOu have R1C1 references checked in your options.

Go to Tools--Options--View and uncheck R1C1 reference.
--
Brevity is the soul of wit.


"connie in maryland" wrote:

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!