Click the Office button

Excel OptionsFormulasWorking with formulas

Uncheck R1C1 reference style

OK


--
Biff
Microsoft Excel MVP


"Kim" wrote in message
...
Can you tell me why when I open an Excel spreadsheet in Excel 2007, the
cell
addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all
the
columns are incorrect. Is there some option that accidentally got
switched?