Columns

[Mark]

My colums changed from letters to numbers. Do not know
why. I want hem to be letters. All my worksheets changes.

 

[Dan E]

Mark,

Go Tools -> Optios and under the General tab uncheck
the R1C1 reference style checkbox.

Dan E

 

[Beth Unglesbee]

Hi Mark,

Check your Tools, Options, General tab. If the "R1C1
reference style" box is checked, then uncheck this setting.

HTH
Beth Unglesbee

 

[Claudia]

-----Original Message-----
My colums changed from letters to numbers. Do not know
why. I want hem to be letters. All my worksheets changes.
.

I had this problem for months before I realized how to
correct it:

Format:
Cells:
Number Tab:
Category = TEXT

Excel reads numbers like formulas, so if you format the
cell to TEXT, it will read exactly what you type and not
try to formulate the information.

Good Luck.

 

[Jim]

I think you misunderstood the question. Tools>Options>General tab>*uncheck
the R1C1 box*>OK.