How do I change column label from number to letter?

[adel]

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.

[Leith Ross]

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

[CLR]

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

Vaya con Dios,
Chuck, CABGx3



"adel" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Michael]

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.

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"adel" <[email protected]> wrote in message
news:[email protected]...
> 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.

[adel]

Thanks everyone. You were very helpful.

Adeline