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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 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? |
#8
|
|||
|
|||
Columns labeled with numbers not letters
Just wanted to say thanks for the answers on this thread...we spent about an
hour trying to figure out how to fix this. Not sure how it got changed to begin with, but using this - we got it done. Thanks. "T. Valko" wrote: 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 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? |
#9
|
|||
|
|||
Columns labeled with numbers not letters
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Dan" wrote in message ... Just wanted to say thanks for the answers on this thread...we spent about an hour trying to figure out how to fix this. Not sure how it got changed to begin with, but using this - we got it done. Thanks. "T. Valko" wrote: 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 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? |
#10
|
|||
|
|||
Columns labeled with numbers not letters
Thank you very much for posting this! I am still not sure how I flipped it,
as I know I was not in that screen before, but at least it is fixed now! "T. Valko" wrote: 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 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? |
Thread Tools | |
Display Modes | |
|
|