This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 92,175 times.
Learn more...
This How.com.vn teaches you how to remove zeros from the beginning (Leading) or end (Trailing) of numbers in Excel.
Steps
- 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.
- 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.Advertisement
- Click Format Cells. The Format Cells dialog will appear.
- 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. 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.
- 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.
- 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.
- Click Format Cells. The Format Cells dialog will appear.
- Select Custom from the left column.
- Type a code into the box under “Type.” If any text is in the box, delete it now. Then, type 0.### into the box.
- Click OK. You will no longer see extraneous zeros at the ends of your numbers.
Expert Q&A
Tips
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.