View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Drregion
 
Posts: n/a
Default Formulas in Excel using [R-1] not A10 references

That did it! Thank you!

"SVC" wrote:

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