Formulas in Excel using [R-1] not A10 references

G

Guest

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
 
G

Guest

That did it! Thank you!

SVC said:
Tools >Options, the General tab, uncheck R1C1 reference style

Drregion said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable row number in Sum($A$1:A10) formula 3
External Data and Formulas 1
VBA formula in macro not working 5
Excel Excel Macro - Variable in a formula 1
XLS Formulas work only in new documents, not in "open"ed ones !!?? 1
using worksheet references in formulas 2
Automatically copy formulas in selected row into a new row? 3
Setting formulas with R1C1 in VBA and eliminate $ 6

Top