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


"Geoff B" wrote in message
...
This is a weird one. Some XL files are opening with column labels being
numbered instead of lettered. But not all of them. (all files are pre
2007
version) Is there some way to change the column labels from numbers back
to
letters in these files?