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
- 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.
-
Picture 1 of How to Remove Leading or Trailing Zeros in Excel 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. -
Picture 2 of How to Remove Leading or Trailing Zeros in Excel Click Format Cells. The Format Cells dialog will appear. -
Picture 3 of How to Remove Leading or Trailing Zeros in Excel Select Number from the left column. -
Picture 4 of How to Remove Leading or Trailing Zeros in Excel Type a '0' (zero) into the 'Decimal Places' box. -
Picture 5 of How to Remove Leading or Trailing Zeros in Excel 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.- If you still see leading zeros, double-click the cells, then press ↵ Enter or ⏎ Return.
Method 2 of 2:
Removing Trailing Zeros
-
Picture 6 of How to Remove Leading or Trailing Zeros in Excel 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. -
Picture 7 of How to Remove Leading or Trailing Zeros in Excel 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. -
Picture 8 of How to Remove Leading or Trailing Zeros in Excel Click Format Cells. The Format Cells dialog will appear. -
Picture 9 of How to Remove Leading or Trailing Zeros in Excel Select Custom from the left column. -
Picture 10 of How to Remove Leading or Trailing Zeros in Excel Type a code into the box under 'Type.' If any text is in the box, delete it now. Then, type 0.### into the box. -
Picture 11 of How to Remove Leading or Trailing Zeros in Excel Click OK. You will no longer see extraneous zeros at the ends of your numbers.
Update 05 March 2020
You should read it
- How to Sort Cells Alphabetically in Excel
- How to handle cells, columns, rows in a spreadsheet in Excel
- How to Move Columns in Excel
- Merge cells in Excel
- How to write leading zeros in Excel
- How to name, comment and protect cells in Excel
- How to Lock Cells in Excel
- Manipulating tables editing in Excel
- How to add zeros to phone numbers in Excel
- How to Prevent Excel from Removing Leading & Trailing Zeros
- How to enter a text into multiple Excel cells at the same time
- How to Remove Spaces Between Characters and Numbers in Excel
Maybe you are interested
Ranking the best laptops in early 2025 How to print two sides of paper in Word, Excel, PDF is extremely simple How to Upload Twitter Videos on Android How to Tweet Alibaba and WeChat are about to add a feature that will allow foreigners to make mobile payments in China Guide to buying a laptop: Tips for shopping