How To Use Zero In Excel

Another way of dealing with zero values in excel is to replace zeros with dash.

How to use zero in excel. Next either press the ctrl 1 combination or use the right click context menu to open the format cells dialog activate the number tab if it isn t. This can be achieved using custom number formatting option as available in excel. Select a blank cell enter below formula and then drag the autofill handle down to copy this formula to other range as you need. Go to the number tab. Use the ctrl 1 keyboard shortcut.

Right click and choose format cells. As soon as you type a zero s before number excel will display a small green triangle in the top left corner of the cell indicating that something is wrong with the cell contents. Select the cell s where you want to prefix numbers with 0. Entering the five zeros forces a fixed length number format. As a result excel doesn t care whether your number starts with a zero or not.

Select the range of cells you want to format. Select the entire data in which you want to replace zeros with dash. To change the number formatting of a cell first select the cell or cells you want to update. Right click the selected range and click format cells from the number tab select custom in the category list and enter 00000 into the type field.