Columns with # designation
 

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?

Columns with # designation
 

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

Columns with # designation
 

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):

ToolsOptionsGeneral, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

"swynne" wrote in message
...
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?

Columns with # designation
 

Great. Thanks for the help. I would have looked for an hour.

"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?