View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Excel Formulas look different

Hi

Goto Tools Options General In Settings section uncheck 'R1C1 reference
style'.

Regards,
Per

"User13" skrev i meddelelsen
...
I received a spreadsheet of mine back from a coworker, and all the formulas
now look something like =Totals!R[3]C[-1] instead of =TOTALS!C73.

Anyone know why they changed and how to change them back?
--
User13