software

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?

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:
gt;
gt; Our company has an Excel document that appears to have been formatted for
gt; excel from something else. The rows and columns both have numbers. If you
gt; open this document all new documents you make have # for rows and columns
gt; until you open an old document that has letters and numbers, then everything
gt; is great.
gt;
gt; What is up with this?

--

Dave Peterson

This is an Excel-wide setting, which means it is applied to all open
workbooks in that instance of Excel.
You can change it (again, for all open workbooks):

Toolsgt;Optionsgt;General, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

quot;swynnequot; gt; wrote in message
...
gt; Our company has an Excel document that appears to have been formatted for
gt; excel from something else. The rows and columns both have numbers. If you
gt; open this document all new documents you make have # for rows and columns
gt; until you open an old document that has letters and numbers, then
gt; everything
gt; is great.
gt;
gt; What is up with this?
Great. Thanks for the help. I would have looked for an hour.

quot;swynnequot; wrote:

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