Browse » Home
Sunday, April 24, 2011
How to Remove Leading Zeroes in Excel
1. Open the spreadsheet that you want to edit in the Microsoft Excel program.
2. Highlight the cells that contain decimal information for which you'd like to remove the leading zero.
3. Right-click the highlighted cells and choose 'Format Cells.' This will open a cell-formatting options window.
4. Click the 'Number' tab and select 'Custom' from the category list.
5. Click the text box underneath the 'Type' heading and press the 'Backspace' key multiple times to clear the contents of the field.
6. Type a decimal point and then type the number of zeroes that correspond to the number of decimal places that you want to display in the cells. For instance, to display three decimal places with no leading zero, you would input: .000.
7. Click the 'OK' button to save your changes. The decimal information in the formatted cells will now be displayed without a leading zero.