Formula's being displayed instead of results

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

Guest

This only happens sometimes, so far when I export data from a GL software.
If I try to insert a column and add a formula, all I get is the formula.
I've tried going through the function - If - etc. I've tried using the
control + shift+ enter. I've tried using brackets. I've tried saving in
current version of excel. I'm using Excel 2003 Professional Edition.
 
You may want to check to see how the cell is formatted. I'm guessing it's
formatted as text.
 
I forgot to mention that I have tried changing the formatting as well -
to/from text/general/number. I've tried inserting new columns with general
formatting. I've tried copying the formula from another spreadsheet. I've
also tried saving it as the current version of Excel that I have (2003).
 
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 VBA 1
Excel Stop Excel from displaying rounded values 4
cell shows formula...not formula result 5
Why does a copied formula display the original answer? 2
Formula in Cell Instead of Result 3
Excel Excel 2007 won't stop rounding down my formula results! 5
Excel Excel Formula - IF Function with percentages 1
Excel How to get output of the formula instead of True or false 1

Back
Top