ExcelBanter - cell reference syntax

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cell reference syntax (https://www.excelbanter.com/excel-worksheet-functions/213860-cell-reference-syntax.html)

cell reference syntax

Excel 2007 recently changed cell reference from =SUM( A1:A10) to
=SUM(R[-10]C:R[-1]C). Don't know why it changed.
How do I get back to original format?

Thanks for any input.
--
Fred

cell reference syntax

In your options in the General Tab, the R1C1 reference style should not have
a check mark.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"Fred" wrote:

Excel 2007 recently changed cell reference from =SUM( A1:A10) to
=SUM(R[-10]C:R[-1]C). Don't know why it changed.
How do I get back to original format?

Thanks for any input.
--
Fred

cell reference syntax

Thanks, that led me to the switch.
No "General" tab but a right click on the menu bar and select Customize then
Formulas got me there.
--
Fred

"Michael" wrote:

In your options in the General Tab, the R1C1 reference style should not have
a check mark.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"Fred" wrote:

Excel 2007 recently changed cell reference from =SUM( A1:A10) to
=SUM(R[-10]C:R[-1]C). Don't know why it changed.
How do I get back to original format?

Thanks for any input.
--
Fred