|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
|
|
#1
July 7th, 2008, 07:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Columns labeled with numbers not letters
My spreadsheets suddenly show numbers for the columns instead of letters --
columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5 How do I change the columns back to letters? 
|
|
#2
July 7th, 2008, 08:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns labeled with numbers not letters
Click Tools/Options on Excel's menu bar, select the General tab on the
dialog box that appears and uncheck the box next to the label "R1C1 reference style" in the Settings section. Rick "plumeria54" wrote in message news  My spreadsheets suddenly show numbers for the columns instead of letters -- columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5 How do I change the columns back to letters?
|
|
#3
July 7th, 2008, 09:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns labeled with numbers not letters
Thank you - that was too easy...!
"Rick Rothstein (MVP - VB)" wrote: Click Tools/Options on Excel's menu bar, select the General tab on the dialog box that appears and uncheck the box next to the label "R1C1 reference style" in the Settings section. Rick "plumeria54" wrote in message news My spreadsheets suddenly show numbers for the columns instead of letters -- columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5 How do I change the columns back to letters?
|
|
#4
September 22nd, 2008, 09:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns labeled with numbers not letters
There is no Tool/Option on the toolbar in Office 2007. How do I get the coumn
headers converted from numbers to letters in this case? "plumeria54" wrote: Thank you - that was too easy...! "Rick Rothstein (MVP - VB)" wrote: Click Tools/Options on Excel's menu bar, select the General tab on the dialog box that appears and uncheck the box next to the label "R1C1 reference style" in the Settings section. Rick "plumeria54" wrote in message news My spreadsheets suddenly show numbers for the columns instead of letters -- columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5 How do I change the columns back to letters?
|
|
#6
January 19th, 2009, 07:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns labeled with numbers not letters
I am having the same problem. Did you find an answer?
"Pella Engineer" wrote: There is no Tool/Option on the toolbar in Office 2007. How do I get the coumn headers converted from numbers to letters in this case? "plumeria54" wrote: Thank you - that was too easy...! "Rick Rothstein (MVP - VB)" wrote: Click Tools/Options on Excel's menu bar, select the General tab on the dialog box that appears and uncheck the box next to the label "R1C1 reference style" in the Settings section. Rick "plumeria54" wrote in message news
My spreadsheets suddenly show numbers for the columns instead of letters -- columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5 How do I change the columns back to letters?
|
|
#7
January 19th, 2009, 07:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns labeled with numbers not letters
In Excel 2007:
Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "tstrong5" wrote in message ... I am having the same problem. Did you find an answer? "Pella Engineer" wrote: There is no Tool/Option on the toolbar in Office 2007. How do I get the coumn headers converted from numbers to letters in this case? "plumeria54" wrote: Thank you - that was too easy...! "Rick Rothstein (MVP - VB)" wrote: Click Tools/Options on Excel's menu bar, select the General tab on the dialog box that appears and uncheck the box next to the label "R1C1 reference style" in the Settings section. Rick "plumeria54" wrote in message news
My spreadsheets suddenly show numbers for the columns instead ofletters -- columns now showing as 1,2,3,4, instead of A,B,C,D. Also formulas in cells now showing up, for example, as RC[-2]*R[-4]C instead of G8*H5 How do I change the columns back to letters?
|
| Thread Tools | |
| Display Modes | |
|
|
Hybrid Mode
