Formulas in Excel using [R-1] not A10 references
Tools Options, the General tab, uncheck R1C1 reference style
"Drregion" wrote:
I converted a Word document into Excel 2003 and when creating formulas,they
are formatted as the cell the formula is in plus or minus a number of rows or
columns. An example: =SUM (R[-4]C:R[-1]C). I would like to see these
formulas in the regular format referencing Row and Column number i.e. =Sum
A1:V52
|