| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the column ID in Excel from number to text?
Currently my column labels in spreadsheets are not showing as text i.e. a,b,c
etc but as 1,2,3 ..... How do I change?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the column ID in Excel from number to text?
Try,
Tools|options|general and un-check R1C1 Mike "Johnboy" wrote: Currently my column labels in spreadsheets are not showing as text i.e. a,b,c etc but as 1,2,3 ..... How do I change?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the column ID in Excel from number to text?
"Mike H" wrote: Try, Tools|options|general and un-check R1C1 Mike Sorry didnt mention I'm using Microsoft office excel 2007 version software and cannot find this option "Johnboy" wrote: Currently my column labels in spreadsheets are not showing as text i.e. a,b,c etc but as 1,2,3 ..... How do I change?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the column ID in Excel from number to text?
Johnboy,
I haven't git 2007 but I'd still bet that what's wrong. Search your help for R1C1. Mike "Johnboy" wrote: "Mike H" wrote: Try, Tools|options|general and un-check R1C1 Mike Sorry didnt mention I'm using Microsoft office excel 2007 version software and cannot find this option "Johnboy" wrote: Currently my column labels in spreadsheets are not showing as text i.e. a,b,c etc but as 1,2,3 ..... How do I change?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the column ID in Excel from number to text?
"Mike H" wrote: Johnboy, I haven't git 2007 but I'd still bet that what's wrong. Search your help for R1C1. Mike Thanks Mike that worked "Johnboy" wrote: "Mike H" wrote: Try, Tools|options|general and un-check R1C1 Mike Sorry didnt mention I'm using Microsoft office excel 2007 version software and cannot find this option "Johnboy" wrote: Currently my column labels in spreadsheets are not showing as text i.e. a,b,c etc but as 1,2,3 ..... How do I change?? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the column ID in Excel from number to text?
Your welcome and thanks for the feedback.
Mike "Johnboy" wrote: "Mike H" wrote: Johnboy, I haven't git 2007 but I'd still bet that what's wrong. Search your help for R1C1. Mike Thanks Mike that worked "Johnboy" wrote: "Mike H" wrote: Try, Tools|options|general and un-check R1C1 Mike Sorry didnt mention I'm using Microsoft office excel 2007 version software and cannot find this option "Johnboy" wrote: Currently my column labels in spreadsheets are not showing as text i.e. a,b,c etc but as 1,2,3 ..... How do I change?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, how do I change the column headings from letters to number | Excel Discussion (Misc queries) | |||
| Change the font size of excel row number and column heading | Excel Discussion (Misc queries) | |||
| How to change number to text in new column from another worksheet? | Excel Worksheet Functions | |||
| Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
| Change column Number vrs Text | Excel Worksheet Functions | |||
Linear Mode
