| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Header - Convert a Number to a letter
I have extract some data from a website and my output file displays a column
in a number value instead of the normal Alphabetic value Is there an option or piece of code that will convert the column headers to letters verses the numbers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Header - Convert a Number to a letter
Found the solution...
Goto ToolsOptionsGeneral tab Uncheck: R1C1 reference style "stickandrock" wrote: I have extract some data from a website and my output file displays a column in a number value instead of the normal Alphabetic value Is there an option or piece of code that will convert the column headers to letters verses the numbers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Letter to Number | Excel Worksheet Functions | |||
| Column Header is not in Letter | Excel Discussion (Misc queries) | |||
| Convert a letter to a number | Excel Discussion (Misc queries) | |||
| How do I convert a given number into a letter? | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Linear Mode
