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

HTTP Error 500.23 - Internal Server Error - Solution 2

Hi,

If you keep visiting here, some days ago, I have posted a same post here. The problem is similar again but difference is another way to solve the same problem.
Lets have a look at fresh snapshot.

HTTP Error 500.23 - Internal Server Error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

Most likely causes:

• This application defines configuration in the system.web/httpHandlers section.

Things you can try:

• Migrate the configuration to the system.webServer/handlers section. You can do so manually or by using AppCmd from the command line - for example, %SystemRoot%\system32\inetsrv\appcmd migrate config "Default Web Site/". Using appcmd to migrate your application will enable it to work in Integrated mode, and continue to work in Classic mode and on previous versions of IIS.
• If you are certain that it is OK to ignore this error, it can be disabled by setting system.webServer/validation@validateIntegratedModeConfiguration to false.
• Alternatively, switch the application to a Classic mode application pool - for example, appcmd set app "Default Web Site/" /applicationPool:"Classic .NET AppPool". Only do this if you are unable to migrate your application.

(Set "Default Web Site" and "Classic .NET AppPool" to your application path and application pool name)

If you are still confused about the previous post, here is the link.
http://www.pyarb.com/2014/02/http-error-50023-internal-server-error.html

Problem

Last time, we received the similar problem while debugging from Visual Studio, this time it is produced by IIS itself after publishing.

Solution

We will add small piece of code into web.config file. This can be done using two methods. Either you open any text-editor (notepad) with Administrator Privilege and open web.config from your IIS root or change the setting in Visual Studio web.config and publish again. What you want to is totally on you.
Piece of Code:

......
<system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
    </system.webServer>
</configuration>

Place this code inside configuration node. Also, this will not harm you in case of security, This will just tell not to check such settings which are not required.
Thanks for reading. Do not forget to share or provide feedback.
+John Bhatt

Read More

Update on Download Center

Hi,

Sorry for the interruption on services of Download Center. Due to some technical mistakes with our web-host and application, all our download files are removed. However, we have all songs available for listening.

Now instead of relying on WordPress and PHP, these days me and my team is busy to develop a CMS based on ASP.NET for Download Center.

We will be back soon.

From
P.Yar.B Complex

Read More