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.
 
Back
Top