ExcelBanter - How do I remove "RC" ?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I remove "RC" ? (https://www.excelbanter.com/excel-discussion-misc-queries/57568-how-do-i-remove-rc.html)

JohnF

How do I remove "RC" ?

Help! my excel formulas have been mysteriously replaced by formulas such as
"=+RC[-2]*RC[2]" instead of the usual A1*B1, etc.....how do I fix this??
thanks

Gary''s Student

How do I remove "RC" ?

Tools Options General and clear the R1C1 reference style
--
Gary''s Student

"JohnF" wrote:

Help! my excel formulas have been mysteriously replaced by formulas such as
"=+RC[-2]*RC[2]" instead of the usual A1*B1, etc.....how do I fix this??
thanks

CLR

How do I remove "RC" ?

Tools Options GeneralTab...........uncheck R1C1 Reference Style box

Vaya con Dios,
Chuck, CABGx3

"JohnF" wrote:

Help! my excel formulas have been mysteriously replaced by formulas such as
"=+RC[-2]*RC[2]" instead of the usual A1*B1, etc.....how do I fix this??
thanks

JohnF

How do I remove "RC" ?

thanks a bunch

"Gary''s Student" wrote:

Tools Options General and clear the R1C1 reference style
--
Gary''s Student

"JohnF" wrote:

Help! my excel formulas have been mysteriously replaced by formulas such as
"=+RC[-2]*RC[2]" instead of the usual A1*B1, etc.....how do I fix this??
thanks

All times are GMT +1. The time now is 03:48 AM.