When entering formula it does not show the value but the formula

  • Thread starter Thread starter SBongiov
  • Start date Start date
S

SBongiov

We received a file and are trying to sum columns but when the person enters
the formula the formula stays visible but not the actual value. I've never
run across this before.
 
You've probably got the cell formatted as text. Format as General (or
Number) & re-enter the formula.
 
The offending cell is probably formatted as text. Change the formatting to
general and reenter you formula.
 
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

Formulas displayed in cell rather than calculated values? 4
Adding up total hours worked on employee schedule using various criteria 0
Need array formula to ignore hidden values 1
Linking Totals Across Multiple Worksheets 2
Searching the formula (not the value) for a text string 1
Problem with SUMIF Formula 3
Formula appears, but its function is not performed????? 1
Formulas to Values 11

Back
Top