change column header from numeric to alphac?
 

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

change column header from numeric to alphac?
 

Goto ToolsOptionsGeneral tab

Uncheck: R1C1 reference style

OK

Biff

"Joe Haddad" <Joe wrote in message
...
I received this spreadsheet from a friend of mine. The column headers are
all
numeric from 1 to whatever. It has got to be simple, but for the life of
me,
I can't find how to convert back to Alpha headers.The formulas are
impossible
to understand, Can someone help?
Thanks

change column header from numeric to alphac?
 

Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks this setting up from the first workbook it opens in that session.
You'll want to remember this just in case you're unlucky <bg.

Joe Haddad wrote:

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

--

Dave Peterson

change column header from numeric to alphac?
 

Oh!
Thank you guys

"Dave Peterson" wrote:

Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks this setting up from the first workbook it opens in that session.
You'll want to remember this just in case you're unlucky <bg.

Joe Haddad wrote:

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

--

Dave Peterson

change column header from numeric to alphac?
 

"Joe Haddad" wrote:

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks

change column header from numeric to alphac?
 

"Joe Haddad" wrote:

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks


How do you do this in Excel 2007?

change column header from numeric to alphac?
 

ButtonExcel OptionsFormulasWorking with formulasR1C1 reference style.

Uncheck it.


Gord Dibben MS Excel MVP


On Mon, 2 Nov 2009 13:50:01 -0800, julia
wrote:



"Joe Haddad" wrote:

I received this spreadsheet from a friend of mine. The column headers are all
numeric from 1 to whatever. It has got to be simple, but for the life of me,
I can't find how to convert back to Alpha headers.The formulas are impossible
to understand, Can someone help?
Thanks


How do you do this in Excel 2007?