Select the Entire Data in which you want to replace zeros with dash.Ģ. Replace Zeros with Dash in ExcelĪnother way of dealing with zero values in Excel is to replace zeros with dash (-). This can be achieved using custom number formatting option as available in Excel.ġ. Once you click on ‘Replace All’ button, all the cells in your data having zeros will immediately become blank. In the expanded ‘Find and Replace’ box, select Match entire cell contents option and click on Replace All button. In ‘Find and Replace’ dialog box, enter 0 in ‘Find what’ Field > leave the ‘Replace with’ field empty (enter nothing in it) and click on Options.Ĥ. Click on the Home tab > click on Find & Select in ‘Editing’ section and select the Replace option in the drop-down menu.ģ. Select the Entire Data in which you want to replace Zeros with blank cells.Ģ. Replace Zeros With Blank in Excelįollow the steps below to replace zeros with blanks in Excel.ġ. With this understanding, let us go ahead and take a look at the steps to replace zeros with blank, dash or text field in Excel. If you replace zeros with Dash (-) or a Text in Excel, you may sometimes encounter errors, if cells with Dash or Text Field are referenced in certain formulas.
