M
Mark
My colums changed from letters to numbers. Do not know
why. I want hem to be letters. All my worksheets changes.
why. I want hem to be letters. All my worksheets changes.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dan E
Mark,
Go Tools -> Optios and under the General tab uncheck
the R1C1 reference style checkbox.
Dan E
Go Tools -> Optios and under the General tab uncheck
the R1C1 reference style checkbox.
Dan E
B
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
Check your Tools, Options, General tab. If the "R1C1
reference style" box is checked, then uncheck this setting.
HTH
Beth Unglesbee
C
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.
J
Jim
I think you misunderstood the question. Tools>Options>General tab>*uncheck
the R1C1 box*>OK.
the R1C1 box*>OK.