Formula

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
 
C

Chris

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
 
Top