From the Color drop-down, choose the white color.In the вЂFormat CellsвЂ™ dialog box, select the вЂFontвЂ™ tab.Select the Format drop-down and click on вЂCustom FormatвЂ™.In the вЂEqual ToвЂ™ dialog box, enter вЂ0вЂ™ in the left field.Place the cursor over the вЂHighlight Cells RulesвЂ™ options and in the options that show up, click on the вЂEqual toвЂ™ option.In the вЂStylesвЂ™ group, click on вЂConditional FormattingвЂ™.Suppose you have a dataset as shown below and you want to hide zeros in the cells.Д«elow are the steps to hide zeros in Excel using conditional formatting: So, if the value in some cells is 0, you can simply program conditional formatting to hide it (or even highlight it if you want). With conditional formatting, you can apply a specific format based on the value in the cells. In case you only want to hide zeros for a specific dataset (or multiple datasets), you can use conditional formatting. While the above method is the most convenient one, it doesnвЂ™t allow you to hide zeros only in a specific range (rather it hides zero values in the entire worksheet). Hide Zero Value in Cells using Conditional Formatting

In case you only want this to hide zero values in a specific range of cells, itвЂ™s better to use other methods covered next in this tutorial. But this is useful only if you want to hide zero values in the entire worksheet. This is the best and fastest method to hide zero values in Excel. Remember that this method only hides the 0 value in the cells and doesnвЂ™t remove these. This change is also applied to cells where zero is a result of a formula. The above steps would instantly hide zeros in all the cells in the selected worksheet. Uncheck the вЂShow a zero in cells that have zero valueвЂ™ option.Scroll down to the section that says вЂDisplay option for this worksheetвЂ™, and select the worksheet in which you want to hide the zeros.In the Excel Options dialog box that opens, click on the вЂAdvancedвЂ™ option in the left pane.Open the workbook in which you want to hide all the zeros.

Suppose you have the sales dataset as shown below and you want to hide all the zero values and show a blank cells instead.Д«elow are the steps to hide zeros from all the cells in a workbook in Excel: LetвЂ™s get started and dive into each of these methods! Automatically Hide Zero Value in CellsД®xcel has an inbuilt functionality that allows you to automatically hide all the zero values for the entire worksheet.ДЄll you have to do is uncheck a box in Excel options, and the change will be applied to the entire worksheet. And in case you use these cells (that have hidden zeroes) in any formula, these will be used in the formula. While the cells may look empty, those cells still contain the 0s.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ClickД(TextBox1.Text, TextBox2.Text, TextBox3.Important Note: When you hide a 0 in a cell using the methods shown in this tutorial, it will only hide the 0 and not remove it. '('Value2', GetType(String))ДataGridView1.DataSource = dtTest.DefaultView 'then uncomment these 3 lines and comment the above 3 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.LoadД('ID', GetType(String))Д('Value1', GetType(String))Д('Value2', GetType(String)) Then comment the first 3 lines where it adds the columns to the datatable, and uncomment the second set of 3 lines. Type data into the textboxes and click the button.

try this in an app with 1 button, 1 datagridview and 3 textboxes. set the column as type String and it will keep your leading zeroes. How are you viewing it? In a datagridview? if you are and you have the column set up as type Integer, it will lose the leading zeroes.

The number 0 disappears in excel