Formula is not working

[maheshmaxi]

Hi,

I am working in an Excel (2007) file which doesn't execute any formula. It shows the formula only in the cell not the result. Even tried basic formulas like sum. No result found. Can anyone help me on this

 

[vinod9111]

press ctrl + ~

 

[repairman615]

Hello,

Look at the formulas tab in the ribbon.

In the formula auditing box look for 'show formula' and click it.

or

use th ekeyboard short cut:

CTRL + `
(the key to the left of the number 1)

Does that work?

 

[maheshmaxi]

Tried using it ctrl + ` and ctrl + shift + `. But no use. Still it is not sorted out.

 

[repairman615]

Just to clarify, you did not include the plus sign right?

In other words it is just two keys.

Also did you try going to the formula tab as described previously?

 

[repairman615]

Here is a line of code that basically does the same:



Sub Macro1()
ActiveWindow.DisplayFormulas = False
End Sub





To use copy the above
Press ALT F11
Keystrokes ALT - I - M
Paste into the module
then use the green play button or Alt F8 and choose macro1.

 

[maheshmaxi]

No. There is no plus sign in my formula. Actually i was trying to put vlookup formula. But it shows formula only. So I tried basic sum formula. But I got the same thing, no result. I am aware of display formula thing already. But I dont think this is related to that. Some times it shows result in this file and other times it is not.

 

[Jon von der Heyden]

Highlight the column that contains the formula that is being displayed.

Go to format cells and remove Text format (choose e.g. General).

Next go to Text to Columns:
Step 1: Delmited
Step 2: Clear all delimiters
Step 3: Click Finish