How to Remove Leading or Trailing Zeros in Excel

Removing Leading Zeros

1. Highlight the cells with leading zeros. If you're working with numbers in a column, you can highlight the whole column by clicking the column letter.
2. 
   Right-click the highlighted cells. If your computer doesn't have a right mouse button, press Ctrl as you click with the left. A menu will appear.
3. 
   Click Format Cells. The Format Cells dialog will appear.
4. 
   Select Number from the left column.
5. 
   Type a '0' (zero) into the 'Decimal Places' box.
6. 
   Click OK. It's at the bottom-right corner of the screen. This brings you back to your spreadsheet, where you should no longer see zeros before your numbers.

   1. If you still see leading zeros, double-click the cells, then press ↵ Enter or ⏎ Return.