formula will not show value

C

Candyman

I have 2007. While scrolling down Excel went into recovery mode. Now my
functions will not show the value in the cell. in Formula wizard the
resultant value is correct, but stil does not transfer to the cell value. I
see the formula only. I tried going to teh Formula toolbar and clicking 'show
Formulas' the cell toggles to show more formula or less.

HELP!
TIA
 
C

Candyman

FYI the display Option under advanced is set to display the value vs. the
formula and set to auto-calculate.
 
G

Gord Dibben

Good chance the cells were re-formatted as text.

Format all to General then select a cell and F2 then ENTER.

OK now?

If many cells you can do an Edit>Replace after formatting all to General.

What: =

With: =

Replace all


Gord Dibben MS Excel MVP
 
C

Candyman

That was it! I had checked the formating and set to general (from text), but
no luck. Replacing the equals sign fixed it. Thanks!
 

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

Drop down list control value in vba 2
Match function: error due to format? 4
formula displays as a formula, not as its result 1
Why does forumula show in cell instead of formula result? 2
Problem with formula for finding last greater than/less than or equal to value 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Cell reference in formula string displays abbreviated value 2
Formulas displayed in cell rather than calculated values? 5

Top