View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ItsVegas_Baby ItsVegas_Baby is offline
external usenet poster
 
Posts: 1
Default How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2)

Former version of Excel was easy and straightforward. However, our French
office has started usig the formula =SUM(R[-56]C:r[-1]c) to add columns which
we do not understand and cannot change. Once we opened a document with this
formula, it changed everything in Excel to this formula, as well as making
the the column indicators numerical rather than alphabetical. We would like
to change the formula and revert back to the standard Excel versions we use
here in the US.

Any help would be appreciated.