Excel using =RC[-1] format and I don't want it

[Just_a_fan]

On this machine only, Excel will use the format =RC[-1] when I am
entering a formula on the command line by hand and click on a cell to
reference it in the formula.

I don't know how this got on but I would like it to go off. On my other
machines, it does the old familiar A1:B2 style of cell reference.

I can't even search for how to fix it since I can't determine what this
is called so I can turn it off. The only reference I have seen is a
button that is only effective for macro creating and I am not creating a
macro, just a formula, interactively, in the cell.

How do I get this off?

Thanks,
Mike Morrow

 

[T. Valko]

Check this setting:

In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK out

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK out

 

[Just_a_fan]

Yup, that does it. Can't figure out how that got on but now it is off.

Thanks for the very speedy answer!!

Mike

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Roman]

is there same option in excel for MAC?