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

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.

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

ToolsOptionsGeneral. Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 12:31:03 -0700, amy wrote:

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.

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

Hi Amy,

Tools | Options | General tab

Uncheck R1C1

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"amy" escreveu:

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.