Weird things happening in Excel

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
 
N

Nick Hodge

Pam

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Weird Things Happening w/Excel2003 2
Table Preferred width is changed when pasting 1
Hidden Excel mystery 0
formula writes itself 0
help on a formula (match and etc..) 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Need Adaptable Macro 9

Top