alter column ref
 

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

alter column ref
 

Excel 2003:-
ToolsOptionsGeneralSettingsUncheck the R1C1 reference style and give
ok.

Excel 2007:-
Press Alt+T+OFormulasWorking 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

alter column ref
 

Go into Excel Options and uncheck R1C1 Reference Style.



--
Regards
Dave Hawley
www.ozgrid.com
"Kaz" wrote in message
...
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

alter column ref
 

In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK out

Other versions of Excel:

ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out

--
Biff
Microsoft Excel MVP


"Kaz" wrote in message
...
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