This setting is picked up from the first workbook you open in that excel
session.

If you share a workbook with a co-worker and that co-worker likes R1C1, you may
find that you have to toggle this setting again (and again and again...).

You'll want to remember how to do it (or just yell at that co-worker!)

Bert wrote:

Thank you very much. I was in the Options section last week and must have
inadvertently checked that box. It has had me frustrated since.
Bert
"Dave Peterson" wrote:

Tools|Options|General tab|Uncheck R1C1 Reference style

Bert wrote:

All of a sudden the designation of columns has appeared as numbers (as well
as the rows) on some spreadsheets. It makes it difficult to track formulas.

--

Dave Peterson


--

Dave Peterson