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