id="info"

Question

Locked

Excel won't show formula results

By tristan_ting ·
i am using excel 2003, whenever i tried to compute with a formula, it only displays the formula on the cell not the result.

this happens intermittently. Please help me.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Do you have auto-calculate turned on?

by ThumbsUp2 In reply to Excel won't show formula ...

Tools -> Options -> Calculation (Tab) -> Calculation -> Automatic

.

Collapse -

Excel formula

by bodibaski In reply to Excel won't show formula ...

Hi ,

I think you are in formula auditing mode means that you could only see the formula instead of result. Try to press control+`(quote symbol, near 1).

Let me know this works or not.
Good luck.

Collapse -

Format the cell first, then enter the formula

by ronone In reply to Excel formula

Credit to Cjohnsonmn in another techrepublic thread:

http://tinyurl.com/yaeypq6

Very weird problem, simple fix. For some reason inserted column on spreadsheet constructed from .csv import did not have a default format. Set format of new column to General and newly entered formulas worked.

Testing showed inconsistent results, some column inserts worked while others did not. Sometimes formula edit worked other times required deletion, format cells then formula reentry.

Bottom line is that new cells missing a default format yield inconsistent results...

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums