Cell Reference Weird Format
 

Hi There,

Somehow I managed to turn my cell references into a weid format... IE: R1C1
and then when I do a formula it is R[-1]C[-2]

Is there any way to turn it back to where the formula reads B3? Thanks!

Cell Reference Weird Format
 

ToolsOptionsGeneral tabuncheck R1C1 reference styleOK

--
Biff
Microsoft Excel MVP


"elementhunter" wrote in message
...
Hi There,

Somehow I managed to turn my cell references into a weid format... IE:
R1C1
and then when I do a formula it is R[-1]C[-2]

Is there any way to turn it back to where the formula reads B3? Thanks!

Cell Reference Weird Format
 

Tools/ Options/ General
Unset R1C1 reference style.
--
David Biddulph

"elementhunter" wrote in message
...
Hi There,

Somehow I managed to turn my cell references into a weid format... IE:
R1C1
and then when I do a formula it is R[-1]C[-2]

Is there any way to turn it back to where the formula reads B3? Thanks!

Cell Reference Weird Format
 

tools -- options -- General tab

Uncheck the R1C1 reference style box

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"elementhunter" escreveu:

Hi There,

Somehow I managed to turn my cell references into a weid format... IE: R1C1
and then when I do a formula it is R[-1]C[-2]

Is there any way to turn it back to where the formula reads B3? Thanks!