In Excel 2007:

Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1
reference styleOK

--
Biff
Microsoft Excel MVP


"Lynn" <Lynn @discussions.microsoft.com wrote in message
...
Hi John -- any advice on how to change the column labels back to letter in
Excel 2007? I can't find the Tools/Options, general Tab you referenced
below
for Excel 2003. Any advice would be appreciated!

Lynn

"John C" wrote:

Go to menu Tools|Options, General tab, uncheck R1C1 reference styles.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"b_wildman" wrote:

How can I change the column headers from numbers to letters? Instead of
rows
labeled as numbers and columns as letters, they are both numbers. EXCEL
2003.

Thanks for the help.