| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Macro Help | Excel Discussion (Misc queries) | |||
| Find and Count Frequency of Numeric Value in Non-Contiguous Rows | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Linear Mode
