Rick Rothstein (MVP - VB) said: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 said: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?
plumeria54 said:Thank you - that was too easy...!
Rick Rothstein (MVP - VB) said: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 said: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?
Pella Engineer said: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 said:Thank you - that was too easy...!
Rick Rothstein (MVP - VB) said: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
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?
Pella Engineer said: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 said:Thank you - that was too easy...!
Rick Rothstein (MVP - VB) said: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
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?
tstrong5 said:I am having the same problem. Did you find an answer?
Pella Engineer said: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 said:Thank you - that was too easy...!
:
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
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?
T. Valko said:In Excel 2007:
Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK
--
Biff
Microsoft Excel MVP
tstrong5 said:I am having the same problem. Did you find an answer?
Pella Engineer said: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?
:
Thank you - that was too easy...!
:
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
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?
Dan said: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 said:In Excel 2007:
Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK
--
Biff
Microsoft Excel MVP
tstrong5 said:I am having the same problem. Did you find an answer?
:
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?
:
Thank you - that was too easy...!
:
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
message
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?
T. Valko said:In Excel 2007:
Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK
--
Biff
Microsoft Excel MVP
tstrong5 said:I am having the same problem. Did you find an answer?
Pella Engineer said: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?
:
Thank you - that was too easy...!
:
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
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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.