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

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.

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

You've probably got the cell formatted as text. Format as General (or
Number) & re-enter the formula.
--
David Biddulph

"SBongiov" wrote in message
...
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.

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

The offending cell is probably formatted as text. Change the formatting to
general and reenter you formula.
--
If this helps, please remember to click yes.


"SBongiov" wrote:

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.

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

Hi,
hit

CTRL + ~ + Enter

"SBongiov" wrote:

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.