Columns labeled with numbers not letters

P

plumeria54

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

Rick Rothstein \(MVP - VB\)

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
 
P

plumeria54

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

Pella Engineer

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

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

tstrong5

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

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

T. Valko

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?

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

Dan

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?

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

T. Valko

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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

John

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

Ask a Question

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.

Ask a Question

Top