How do I change column label from number to letter?
 

Hi,

Usually, the rows are numbers and the colums letters. Right now, my columns
are numbers also. How can I get it fixed because this is really confusing for
formulas.
Thank you.

Tools Options GeneralTab..........uncheck the R1C1 reference style
box.............

Vaya con Dios,
Chuck, CABGx3



"adel" wrote in message
...
Hi,

Usually, the rows are numbers and the colums letters. Right now, my
columns
are numbers also. How can I get it fixed because this is really confusing
for
formulas.
Thank you.

Hello Adel,

On the Excel Toolbar select: Tools | Options | General (tab) | Settings
| R1C1 Reference Style (check box)

Click the Check Box. The Check Mark will disappear. Click OK and your
Columns will display letters again instead of numbers.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=381396

Hi Adel. Go to Tools - Options and on the General Tab, deselect "R1C1"
reference style. HTH
--
Sincerely, Michael Colvin


"adel" wrote:

Hi,

Usually, the rows are numbers and the colums letters. Right now, my columns
are numbers also. How can I get it fixed because this is really confusing for
formulas.
Thank you.

Tools--Options--General tab. Untick R1C1 reference style.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"adel" wrote in message
...
Hi,

Usually, the rows are numbers and the colums letters. Right now, my
columns
are numbers also. How can I get it fixed because this is really confusing
for
formulas.
Thank you.

Thanks everyone. You were very helpful.

Adeline