Microsoft Excel : Formula Result not showing

Hi,
Lets get known to a common Microsoft Excel issue.

Issue/Problem

Last day, I was working with a file in my office. That file was in Microsoft Excel format and I have to analyze data. When placing some formula, I noticed, excel is not calculating formula.
Lets be clear with following screenshot.

I tried many thing, Converted File to older format, newer format, opened and closed in other system and many other tricks but no one worked.

Actual Cause

Then suddenly I show the Format of the textbox where formula is placed. That is of kind Text and was the actually reason for not calculating formula. Microsoft Excel treats everything as normal Text string while placed or formatted as Text.

Solution

I have following two simple steps and Results are back.
Step 1: Changed formatting of Cell to Number which is of course my data type for the result. Lets have look at below screen to be more clear.

Step 2: Clicked in Cell to go to edit mode and pressed Enter key without any modification as formula was correct. Have a look at this screen to confirm.

Problem solved.

If you find my posts helpful, do not forget to share on social network or with your friends. Suggestions and feedback are awaited and always welcome.

+John Bhatt 

Read More

SLC 2070 Result Published

Hi,

Office Of The Controller Of Examinations has published result of SLC examinations taken on 2070 BS. Meanwhile, result is not available to view, we have downloaded their database and uploaded to our website. You can follow below link to get your result.
http://www.johnbhatt.com/Results.aspx

http://www.johnbhatt.com/Results.aspx

Congratulations and All the Best for all students who passed, for those students whose roll number is not in list, do not worry, you can check your marksheet soon and final result might change.

Thanks,
+John Bhatt 

Read More