| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
