Browse » Home
Thursday, April 25, 2013
How to Lose the Zeroes in Excel
All Zero Values
1. Move your mouse pointer to the 'File' tab and left-click. Click 'Options.'
2. Find the 'Advanced' category at the top and click it. Locate 'Display options for this worksheet' and select your worksheet.
3. Remove the check beside 'Show a zero in cells that have zero value.' The cells with zero values now appear blank and contain no numbers.
Selected Cells
4. Move your mouse pointer to the cells with zero values that you want to lose. Hold down the left button and drag your mouse. This highlights the cell(s).
5. Locate the 'Cells' group in the 'Home' tab. Click 'Format.' followed by 'Format Cells.'
6. Find the 'Category' list. Click on 'Custom.'
7. Type '0;-0;;@', without the quotation marks, in the 'Type' box. This hides the zero values.