Formula

Copper Contributor

Hi, apologies if this is very basic but I have noticed that all my basic excel formulas eg SUM and  autosum have changed and instead of seeing the row and cell references eg SUM(A1:G7) the formulas are now shown in this type of format  SUM(R[-17]C:R[-1]C). As I do not understand the logic I am worried the formula may be incorrect.  I am sure this is a setting which has changed but I have not been able to find it. Can anyone please tell me what I need to change so that I see the simple row and cell numbers ?

Many thanks

 

2 Replies

@haloes Go to Excel, Preferences..., General. Uncheck "Use R1C1 references style"

Screenshot 2020-02-24 at 12.34.38.png

@Riny - Many thanks, so simple if you know where to look. thanks for the prompt reply too !