formula bar displays "=RC[-12]+RC[-11]". how to get normal view?

[Guest]

Hi,

The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]"
but I don't remember changing any setting.

Does anybody know how to get back to normal view in the formula bar, i.e
"=D9+D10"?

Thanks

Laurent

 

[Guest]

It remembers the settings from the last workbook opened.

Tools - Options - general Un-check RICI

 

[Sandy Mann]

Tools > Options > General and uncheck R1C1 Reference Style

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

Thank you!

It remembers the settings from the last workbook opened.

Tools - Options - general Un-check RICI

Hi,

The formula bar in my worksheet displays something like "=RC[-12]+RC[-11]"
but I don't remember changing any setting.

Does anybody know how to get back to normal view in the formula bar, i.e
"=D9+D10"?

Thanks

Laurent