Thread: change column header from numeric to alphac?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?


Reply With QuoteReply With Quote