HomeApplicationOffice information

How to Remove Leading or Trailing Zeros in Excel

This wikiHow teaches you how to remove zeros from the beginning (Leading) or end (Trailing) of numbers in Excel. Highlight the cells with leading zeros. If you're working with numbers in a column, you can highlight the whole column by...
Method 1 of 2:

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. How to Remove Leading or Trailing Zeros in Excel Picture 1How to Remove Leading or Trailing Zeros in Excel Picture 1
    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. How to Remove Leading or Trailing Zeros in Excel Picture 2How to Remove Leading or Trailing Zeros in Excel Picture 2
    Click Format Cells. The Format Cells dialog will appear.
  4. How to Remove Leading or Trailing Zeros in Excel Picture 3How to Remove Leading or Trailing Zeros in Excel Picture 3
    Select Number from the left column.
  5. How to Remove Leading or Trailing Zeros in Excel Picture 4How to Remove Leading or Trailing Zeros in Excel Picture 4
    Type a '0' (zero) into the 'Decimal Places' box.
  6. How to Remove Leading or Trailing Zeros in Excel Picture 5How to Remove Leading or Trailing Zeros in Excel Picture 5
    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.
Method 2 of 2:

Removing Trailing Zeros

  1. How to Remove Leading or Trailing Zeros in Excel Picture 6How to Remove Leading or Trailing Zeros in Excel Picture 6
    Highlight the cells with trailing zeros. If you're working with numbers in a column, you can highlight the whole column by clicking the column letter.
  2. How to Remove Leading or Trailing Zeros in Excel Picture 7How to Remove Leading or Trailing Zeros in Excel Picture 7
    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. How to Remove Leading or Trailing Zeros in Excel Picture 8How to Remove Leading or Trailing Zeros in Excel Picture 8
    Click Format Cells. The Format Cells dialog will appear.
  4. How to Remove Leading or Trailing Zeros in Excel Picture 9How to Remove Leading or Trailing Zeros in Excel Picture 9
    Select Custom from the left column.
  5. How to Remove Leading or Trailing Zeros in Excel Picture 10How to Remove Leading or Trailing Zeros in Excel Picture 10
    Type a code into the box under 'Type.' If any text is in the box, delete it now. Then, type 0.### into the box.
  6. How to Remove Leading or Trailing Zeros in Excel Picture 11How to Remove Leading or Trailing Zeros in Excel Picture 11
    Click OK. You will no longer see extraneous zeros at the ends of your numbers.
4.1 ★ | 8 Vote
clickcellscolumn

You should read it

Maybe you are interested

Office information