Tools/ Options/ General
Uset R1C1 reference style
--
David Biddulph

"ItsVegas_Baby" wrote in message
...
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.