Tools|Options|General Tab
Uncheck R1C1 Reference style.

Excel will pick up this setting from the first workbook you open in that session
of excel.

swynne wrote:

Our company has an Excel document that appears to have been formatted for
excel from something else. The rows and columns both have numbers. If you
open this document all new documents you make have # for rows and columns
until you open an old document that has letters and numbers, then everything
is great.

What is up with this?

--

Dave Peterson