Formula

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

Hi,

My formulas are displaying as r and c values

eg =R[-9]C/R2C4

I would like to see the cell reference.

Any ideas?

Thanks,
Sally
 
Sally,
First thing to check:
Under Tools in the menu, click Options, then select the General tab. The
first setting is a checkbox called "R1C1 reference style". Make sure this
is not checked, and Excel should display them properly.
HTH
Chris
 

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

making code more efficient 2
help making code more effecient 2
Require formula to search across multiple worksheets 2
external links 2
Excel VBA 1
What is the syntax for control+UpArrow in Macro? 2
Excel How to code in excel vba 2007 using absolute refernce for cells 1
Copying a formula while leaving one cell fixed 1

Back
Top