Weird Things Happening w/Excel2003

R

rayzgurl

Work just upgraded our office products and now older spreadsheets ar
showing up with row numbers and column numbers instead of Row Number
Column Letters. This has messed up all of the formulas and no one ca
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!

-Pa
 
F

Frank Kabel

Hi
Go to Tools-Options-General and uncheck the box marked "R1C1 reference
style"
 

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

Weird things happening in Excel 1
An odd problem with SUM(A:B) and AutoSum 2
Concatenate not working 3
Column chngd fm letters to numbers. What that & how do I go back? 1
How to add a "running count" to cells with matching data 2
problem with an averaging formula 2
adding multiple values from matched search results 3
Help with writing a macro to create a list 1

Top