How to Remove Leading or Trailing Zeros in Excel
Highlight the cells with leading zeros., Right-click the highlighted cells., Click Format Cells.,Select Number from the left column.,Type a “0” (zero) into the “Decimal Places” box., Click OK. It’s at the bottom-right corner of the screen.
Step-by-Step Guide
-
Step 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. , If your computer doesn’t have a right mouse button, press Ctrl as you click with the left.
A menu will appear., The Format Cells dialog will appear.,,, 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. -
Step 2: Right-click the highlighted cells.
-
Step 3: Click Format Cells.
-
Step 4: Select Number from the left column.
-
Step 5: Type a “0” (zero) into the “Decimal Places” box.
-
Step 6: Click OK. It’s at the bottom-right corner of the screen.
Detailed Guide
If you’re working with numbers in a column, you can highlight the whole column by clicking the column letter. , If your computer doesn’t have a right mouse button, press Ctrl as you click with the left.
A menu will appear., The Format Cells dialog will appear.,,, 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.
About the Author
Edward Parker
A seasoned expert in arts and creative design, Edward Parker combines 5 years of experience with a passion for teaching. Edward's guides are known for their clarity and practical value.
Rate This Guide
How helpful was this guide? Click to rate: