View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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