Weird things happening in Excel

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

Work just upgraded our office products and now older
spreadsheets are showing up with row numbers and column
numbers instead of Row Numbers Column Letters. This has
messed up all of the formulas and no one can make changes
because they have no idea how to re-write the formulas.
HELP!!! is there a setting in Excel that we are missing???

Thanks!

-Pam
 
Pam

Tools>Options...>General> Uncheck R1C1 reference style

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top