| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
my coloumn id's have #'s ie 1,2,3 & I want to see alpha ie A,B,C
I opened a blank workbook in excel (2003) and my coloumn id's were numbers in
lieu of alpha characters. How do I reset this to be Alpha's? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my coloumn id's have #'s ie 1,2,3 & I want to see alpha ie A,B,C
toolsoptionsgeneralr1c1
-- Don Guillett Microsoft MVP Excel SalesAid Software "Benita" wrote in message ... I opened a blank workbook in excel (2003) and my coloumn id's were numbers in lieu of alpha characters. How do I reset this to be Alpha's? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my coloumn id's have #'s ie 1,2,3 & I want to see alpha ie A,B,C
Click TOOLS in the menu and select OPTIONS. Click the GENERAL tab and remove
the check next to R1C1 REFERENCE STYLE in the settings panel. -- Kevin Backmann "Benita" wrote: I opened a blank workbook in excel (2003) and my coloumn id's were numbers in lieu of alpha characters. How do I reset this to be Alpha's? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my coloumn id's have #'s ie 1,2,3 & I want to see alpha ie A,B,C
Tools/ Options/ General:
Unset R1C1 reference style. -- David Biddulph "Benita" wrote in message ... I opened a blank workbook in excel (2003) and my coloumn id's were numbers in lieu of alpha characters. How do I reset this to be Alpha's? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique ID's | New Users to Excel | |||
| User ID's | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
| column id's | Setting up and Configuration of Excel | |||
| Face ID's | Excel Discussion (Misc queries) | |||
Linear Mode
