M Mark Oct 6, 2003 #1 My colums changed from letters to numbers. Do not know why. I want hem to be letters. All my worksheets changes.
My colums changed from letters to numbers. Do not know why. I want hem to be letters. All my worksheets changes.
D Dan E Oct 6, 2003 #2 Mark, Go Tools -> Optios and under the General tab uncheck the R1C1 reference style checkbox. Dan E
B Beth Unglesbee Oct 6, 2003 #3 Hi Mark, Check your Tools, Options, General tab. If the "R1C1 reference style" box is checked, then uncheck this setting. HTH 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
C Claudia Oct 7, 2003 #4 -----Original Message----- My colums changed from letters to numbers. Do not know why. I want hem to be letters. All my worksheets changes. . Click to expand... 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.
-----Original Message----- My colums changed from letters to numbers. Do not know why. I want hem to be letters. All my worksheets changes. . Click to expand... 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 Oct 7, 2003 #5 I think you misunderstood the question. Tools>Options>General tab>*uncheck the R1C1 box*>OK.
