Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2)

357 views
Skip to first unread message

ItsVegas_Baby

unread,
Jan 23, 2009, 1:33:04 PM1/23/09
to
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.

David Biddulph

unread,
Jan 23, 2009, 1:39:45 PM1/23/09
to
Tools/ Options/ General
Uset R1C1 reference style
--
David Biddulph

"ItsVegas_Baby" <ItsVeg...@discussions.microsoft.com> wrote in message
news:D3DCA649-22BA-414F...@microsoft.com...

ItsVegas_Baby

unread,
Jan 23, 2009, 2:03:02 PM1/23/09
to
This solution was the easy way to do it in the old version of Excel, but we
could not find Tools, etc. in the 2007 version. I finally did a search in
Help for Tools, and found the answer. Thank you tho for your prompt reply.

Rick Rothstein

unread,
Jan 23, 2009, 2:15:11 PM1/23/09
to
Click the Office Button (the round circular icon in the upper left corner of
the window), click the "Excel Options" button in the bottom of the dialog
box that comes up, select Formulas from the left-hand list and unset the
"R1C1 reference style" option located in the "Working with formulas"
section.

--
Rick (MVP - Excel)


"ItsVegas_Baby" <ItsVeg...@discussions.microsoft.com> wrote in message

news:A914EEA2-58BF-417B...@microsoft.com...

0 new messages