Prev: leftmost number value
Next: Please help to search a custom format
From: Kaz on 26 Apr 2010 21:23
my column references are displayed in numeric rather than alphabetic. eg. the
first column is 1, instead of A. Can anyway help me? thanks Kaz
From: Ms-Exl-Learner on 26 Apr 2010 21:51
Excel 2003:-
Tools>>Options>>General>>Settings>>Uncheck the R1C1 reference style and give
ok.

Excel 2007:-
Press Alt+T+O>>Formulas>>Working with formulas>> Uncheck the R1C1 reference
style and give ok.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Kaz" wrote:

> my column references are displayed in numeric rather than alphabetic. eg. the
> first column is 1, instead of A. Can anyway help me? thanks Kaz
From: ozgrid.com on 26 Apr 2010 21:52
Go into Excel Options and uncheck R1C1 Reference Style.



--
Regards
Dave Hawley
www.ozgrid.com
"Kaz" <Kaz(a)discussions.microsoft.com> wrote in message
news:1A6494E2-EC8A-43AD-AA5F-EC4ED06E5904(a)microsoft.com...
> my column references are displayed in numeric rather than alphabetic. eg.
> the
> first column is 1, instead of A. Can anyway help me? thanks Kaz

From: T. Valko on 26 Apr 2010 21:55
In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK out

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK out

--
Biff
Microsoft Excel MVP


"Kaz" <Kaz(a)discussions.microsoft.com> wrote in message
news:1A6494E2-EC8A-43AD-AA5F-EC4ED06E5904(a)microsoft.com...
> my column references are displayed in numeric rather than alphabetic. eg.
> the
> first column is 1, instead of A. Can anyway help me? thanks Kaz


 | 
Pages: 1
Prev: leftmost number value
Next: Please help to search a custom format