Cell displays Formula text

G

Guest

Can anyone explain why cell will display the "text of a formula" instead of
the formula results? I have checked to confirm that the cell is not forced
text (no ' beginning value. When I edit the cell, Excel recognizes that the
cell contains a formula and returns the expected result. The function of the
formula does not seem to part of the issue. I have received this strange
situation with the 'sum' and 'left' functions.
 

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

Cell shows the last typed text, no matter where it is typed 0
Can a text box use a formula or cell reference 3
Formula text in woorksheet cell 2
Number/Text combination formula 8
Compare formula result with text 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Simple Formula displays "0" 1
Clearing content from a cell (or a group) but retain its formula 2

Top