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

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.
 
D

David Biddulph

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

Paul C

The offending cell is probably formatted as text. Change the formatting to
general and reenter you formula.
 

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

Searching the formula (not the value) for a text string 1
SUMIF Help 4
Formulas displayed in cell rather than calculated values? 5
Linking Totals Across Multiple Worksheets 3
Need array formula to ignore hidden values 1
Spread values across fields 1
Formula appearing as Value in Formula Bar 1
Macro/Forumula to SUM values from Sheet that does not always exist 1

Top