Formula displays instead of value

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

Guest

Corporate sends Excel spreadsheets that do not allow entry of a formula. If a
formula is entered it shows with the leading = sign. I cannot get it to
display the value of the formula. Have tried formatting the cells to number,
but that does not work. If I copy the formula to a blank spreadsheet it
displays the value properly. Please help with suggestions. thanks,
Ron
 
Hi
after changing the format to 'Number' or 'General' re-enter the
formula. If this does not help check under 'Tools - Options - View'
that 'formulas' is unchecked
 
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

Help needed 0
Excel Formula Bar Time Display Format 2
excel displays formula instead of value in one cell 3
Zero Values 2
Entering a Formula; Remains a Formula Instead of Calculating 1
Excel won't resolve formula in one column 3
Excel formula, sum the value cell and if empty cell left blank 0
Excel How to get output of the formula instead of True or false 1

Back
Top