Formula showing in the cell but not the result.

[Majen]

I have a formula in a cell and when I use the formula bar it shows me the correct answer but it doesn't show me it in the worksheet. Only the formula shows up.

The same formula could be another place in my worksheet and work fine.

I have tried changing format. Copying formula from another location and changing the information to fit my needs it won't show me the result.

Help!

Thank you.

 

[PaddyD]

Learnt it here, I'm sure

 

[jovihava]

This thread just saved my day

 

[metropoj]

None of these things worked for me.

In my case, I had to select the column that I wanted the formulas entered in right clicked, and changed format to General from 'text', then it worked ...

 

[chrisl4]

I know this is an old post but here is what works in Excel 2007. From the Microsoft help files.
Switch between displaying formulas and their values on a worksheet

• Press CTRL + ` (grave accent).

 

[barcmjm]

I had the same problem but the tricks above didn't work. Another work around is to copy and paste the cells displaying the formulas in to a word document and cut and pasting them back in to the excel worksheet.

 

[Jenawade]

I had the same problem but the tricks above didn't work. Another work around is to copy and paste the cells displaying the formulas in to a word document and cut and pasting them back in to the excel worksheet.

I read about a little trick around here somewhere that has always (so far) helped me out of these kinds of situations. Try typing a 1 (one) in a blank cell. Copy that 1. Select your problem cells, bring up paste special, choose multiply.

 

[NumberMonkey]

I've seen this anomaly as well.

The solution I found is quick & easy.

Simply edit the cell with the formula, place a single quote at the beginning of your formula, press enter to insert your change, then remove the single quote and Excel is forced to evaluate the format for the cell.

I'm guessing there's a little event bug in Excel here. There seems to be a failure to automatically kick off the format decision routine or whatever it's called.

 

[eva.l2g]

Metropoj - your suggestion worked for me, thanks!

 

[tcordell8891]

The issue is the format of the cells before the function is typed. If the format of the cells is TEXT before you type the function, it will display anything you type in that field as text. Here is the solution:

1. Right click the cell with the formula, Choose Format Cells.
2. In th Number Tab, choose General.
3. Click OK.
4. Double click on your formula in the cell, and press enter.

Viola, you should see the function result instead of the formula text.

 

[imnegan]

Hi all, just had the same problem, here's how I fixed it:

Press CTRL + ` (grave accent).

This switches between displaying formulae and result.