View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SVC
 
Posts: n/a
Default 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