HomeApplicationOffice informationHow to Remove Leading or Trailing Zeros in Excel

How to Remove Leading or Trailing Zeros in Excel

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 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 2
    Click Format Cells. The Format Cells dialog will appear.
  4. How 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 4
    Type a '0' (zero) into the 'Decimal Places' box.
  6. How 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 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 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 8
    Click Format Cells. The Format Cells dialog will appear.
  4. How 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 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 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

May be interested

  • How to Run Regression Analysis in Microsoft ExcelPhoto of How to Run Regression Analysis in Microsoft Excel
    regression analysis can be very helpful for analyzing large amounts of data and making forecasts and predictions. to run regression analysis in microsoft excel, follow these instructions. if your version of excel displays the ribbon (home,...
  • How to Add Up Columns in ExcelPhoto of How to Add Up Columns in Excel
    this wikihow teaches you how to add two or more columns together in an excel document. you can use the sum command on both windows and mac versions of excel to do so. open your excel document. double-click the excel document that you want...
  • How to Search for Words in ExcelPhoto of How to Search for Words in Excel
    an excel document can be overwhelming to look through. thankfully, you can use the search function to conveniently locate a particular word, or group of words, in an excel worksheet. launch ms excel. do this by clicking on its icon in your...
  • How to Unshare an Excel WorkbookPhoto of How to Unshare an Excel Workbook
    this wikihow teaches you how to stop sharing a microsoft excel document on desktop, iphone, and android platforms. open excel. it's a green app with a white 'x' on it. to open a shared document that you wish to unshare, you'll need to load...
  • How to Use the Sum Function in Microsoft ExcelPhoto of How to Use the Sum Function in Microsoft Excel
    using the sum function in excel is an easy way to save yourself lots of time. decide what column of numbers or words you would like to add up
  • How to Integrate Large Data Sets in ExcelPhoto of How to Integrate Large Data Sets in Excel
    these instructions will show you how to approximate integrals for large data sets in microsoft excel. this can be particularly useful when analyzing data from machinery or equipment that takes a large number of measurements—for example, in ...

Office information