Group:  Microsoft Excel ยป microsoft.public.excel.setup
Thread: both columns and rows are numeric.want the columns to be alpha

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

both columns and rows are numeric.want the columns to be alpha
amy 26.09.2006 19:31:03
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.
Re: both columns and rows are numeric.want the columns to be alpha
Gord Dibben <gorddibbATshawDOTca> 26.09.2006 20:05:18
Tools>Options>General. Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 12:31:03 -0700, amy <amy[ at ]discussions.microsoft.com> wrote:

[Quoted Text]
>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.

RE: both columns and rows are numeric.want the columns to be alpha
Marcelo 26.09.2006 20:16:02
Hi Amy,

Tools | Options | General tab

Uncheck R1C1

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



"amy" escreveu:

[Quoted Text]
> 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.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net