| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I convert column labels back to alphabetic from numeric?
My Excel spreadsheet column labels have mysteriously converted to a numeric
format the same as lines. No idea why, I just want to go back to having them listed as A, B, C etc. Can anyone help please? many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert column labels back to alphabetic from numeric?
Click the circular office button on the top left, select "Excel Options"
select the formulas menu and under working with formulas change the "R1C1 reference style" so that it is not ticked. Hope that helps Paul "Razorbill" wrote: My Excel spreadsheet column labels have mysteriously converted to a numeric format the same as lines. No idea why, I just want to go back to having them listed as A, B, C etc. Can anyone help please? many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert column labels back to alphabetic from numeric?
In versions 2003 or older, click TOOLS in the menu and select OPTIONS. In
the dialog box click the GENERAL tab and turn of the R1C1 REFERENCE STYLE, which is the first check box in the SETTINGS panel. -- Kevin Backmann "Razorbill" wrote: My Excel spreadsheet column labels have mysteriously converted to a numeric format the same as lines. No idea why, I just want to go back to having them listed as A, B, C etc. Can anyone help please? many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I convert column labels back to alphabetic from numeric?
Tools/ Options/ General
Uncheck: R1C1 reference style -- David Biddulph "Razorbill" wrote in message ... My Excel spreadsheet column labels have mysteriously converted to a numeric format the same as lines. No idea why, I just want to go back to having them listed as A, B, C etc. Can anyone help please? many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format of column need to change back to Alpha not numeric | Excel Discussion (Misc queries) | |||
| Column headings are numeric rather than alphabetic | Excel Discussion (Misc queries) | |||
| How do I re-set my column labels from 1,2,3 back to A,B,C ? | Setting up and Configuration of Excel | |||
| HIghest Value - Numeric and Alphabetic | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Hybrid Mode
