both columns and rows are numeric.want the columns to be alpha

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amy - 26 Sep 2006 20:31 GMT

in my excel sheet. the top of the columns are numeric as well as the rows. I
want the columns to be alpha???
There could be some special format or sumation happening prior to getting
the excel file.

Reply to this Message

Gord Dibben - 26 Sep 2006 21:05 GMT

Tools>Options>General. Uncheck "R1C1 reference style"

Gord Dibben MS Excel MVP

>in my excel sheet. the top of the columns are numeric as well as the rows. I
>want the columns to be alpha???
>There could be some special format or sumation happening prior to getting
>the excel file.

Reply to this Message

Marcelo - 26 Sep 2006 21:16 GMT

Hi Amy,

Tools | Options | General tab

Uncheck R1C1

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> in my excel sheet. the top of the columns are numeric as well as the rows. I
> want the columns to be alpha???
> There could be some special format or sumation happening prior to getting
> the excel file.

Reply to this Message