We can see the number but there is an apostrophe that indicates the number is in text format. To understand the reason for showing 0 select cell C5 and look at the formula bar.Here the formula returns 0 because the COUNTfunction counts the number of cells that contain numbers not text. Input the formula in cell C10 to calculate the total quantity:.Suppose we want to calculate the number of total books in cell C10. The dataset consists of the names of some books and the available quantity of those books in that book store.
In the following screenshot, we have a dataset of a bookstore. In this method, we will convert text to numbers with a mouse click to fix the problem of the formula result showing 0 in excel. To solve this problem we will convert text to numbers.ġ.1 Convert Text to Number with Mouse Click 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. 3 Effective Solutions to Formula Result Showing 0 in Excel