how can i stop formulas from displaying like this =R[-49]C+R[-25]

  • Thread starter Thread starter calculator1
  • Start date Start date
C

calculator1

it should look like =sUM(a1:a3), without all the brackets etc.
 
Click Tools > Options > General tab
Uncheck "R1C1 reference style" > OK
 
If you make the change below you will also experience the following change:
The column headings in your spreadsheet will change from numbers to the
Excel default of letters.
 
The column headings in your spreadsheet will change from numbers to the
Excel default of letters.
Click to expand...

Of course, that is what I believe the OP wants ..

---
 
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

Scrabble Value calculation for Welsh words 0
Calculating weighted average of Percent Change 0
Extract Formula to Text 6
Creating a formula relating to several cells 2
Excel Formulas are showing relative address, rather than absolute 3
can I write a function that automatically changes over time 3
Formula in dropdown list 2
Is there any programming tool which can calculate single worksheet 3

Back
Top