| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column and Row labels are numeric
Both my column and row labels are numeric. Example: cell A1 is now R1C1.
How can I get the column back to alpha? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Column and Row labels are numeric
In xl2003:
Tools|Options|General tab|uncheck R1C1 reference style TJtheDJ wrote: Both my column and row labels are numeric. Example: cell A1 is now R1C1. How can I get the column back to alpha? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Column and Row labels are numeric
Tools Options General [ ] R1C1 Reference style
Uncheck that. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "TJtheDJ" wrote: Both my column and row labels are numeric. Example: cell A1 is now R1C1. How can I get the column back to alpha? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert column labels back to alphabetic from numeric? | Excel Discussion (Misc queries) | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Worksheet Column Labels ... Alphabet or Numeric ? | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Linear Mode
