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?

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
...
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?

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
...
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?

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
...
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?

We definitely need a FAQ for this group.

2003 to 2007 cross-reference:
http://office.microsoft.com/en-us/ex...491511033.aspx
--
David Biddulph

"Pella Engineer" <Pella wrote in message
...
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
...
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?

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
...
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?

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
...
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?