Feb 24 2020 03:24 AM
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
Feb 24 2020 03:39 AM
@haloes Go to Excel, Preferences..., General. Uncheck "Use R1C1 references style"
Feb 24 2020 03:43 AM