formula looks strange in excel cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help, because I forgot what to do to change this back.

I opened a spreadsheet this morning and in one of the cells, instead of the
regular formula I was expecting, (eg, sum e30:e50), you get something like
this:

SUM(R[-27]C:R[-3]C)

I am sure this is an easy re-set to the normal mode.

Thanks for any help you can provide,
Ann
 
Go to Tools-Options-General.
Uncheck 'R1C1 reference style'

Regards,
Paul
 
That means R1C1 reference style is set, Row1Column1. Your column headers
should also be numbers instead of the usual letters.

Goto Tools>Options>Genaeral tab> uncheck R1C1 reference style>OK

Biff
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
Excel How to add numbers in same cell? 2
Excel Excel Macro - Variable in a formula 1
sum format in formula bar 3
Formulas in Excel using [R-1] not A10 references 2
Cell shows the last typed text, no matter where it is typed 0
Including cells that are highlighted in a formula 2
Sum to the last row in vba 2

Back
Top