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

K

KIM W

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.
 

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

adding multiple values from matched search results 3
extracting R-squared value from a chart 3
Formula in dropdown list 2
Creating a formula relating to several cells 2
Returning comlumn hearder uppon matching a text sting in a row 4
Lookup values if Value 1 is x or y and Value 2 is a,b,c,d. 3
OR in SUMPRODUCT formula 4
Excel Formulas are showing relative address, rather than absolute 3

Top