So, the formula returns 0 instead of the actual result. Sometimes the numbers in data are stored in text format. To fix the problem of the formula result showing 0 in excel first and foremost, we will check the data in our dataset that we will input into the formula. Fix Formula Result Showing 0 by Converting Text to Number To illustrate the solutions to you, we will use the same dataset for ‘ solution-1’ and ‘ solution-2’ and slightly modified dataset for ‘ solution-3’.ġ.

We will discuss 3 effective solutions to fix the problem of the formula result showing 0 in excel. Application.DisplayFormulaBar = False ‘hides formula barĪpplication.3 Effective Solutions to Formula Result Showing 0 in Excel You need to set these properties to False to hide them. Once you hide the formula bar, it will become hidden for all workbooks. This property is under the Application object. Another common scenario is to hide (or unhide) formula bar automatically to force the workbook to keep that layout. With simple a VBA code, you can hide or show the formula bar with a single click. Click the OK button to apply your changes.Check or uncheck the Show Formula bar option depending on your preferences.In the Excel Options dialog, activate the Advanced option.Click Options to activate the Excel Options.Or, click the Office button in Excel 2007. Click on the File tab if you are using Excel 2010 or higher version.Follow the steps below to open this dialog and access the options. You can find the corresponding preferences for the Excel Options options in the corresponding dialog window. Hide or unhide formula bar using the Excel Options Uncheck or check the Formula Bar option in the Show section.When you have an active Excel workbook, follow the steps below. This option can be found directly on the Ribbon. Hide or unhide formula bar using the Excel Ribbon You have 3 options to do this: using the Excel Ribbon, Excel Options, or VBA. In this guide, we’re going to show you how to make Excel show formula bar or hide it. Alternatively, you may want to show it instead, if the bar is missing. However, you may want to hide the formula bar either to limit user interaction with it, or to give your Excel workbook a compact look and feel. By default, the formula bar is visible in Excel to allow you to see and enter formulas in the active cell.

Excel is showing formula not result