Remove Leading Zeros from a Number Column in Excel
Question details
The user wants to remove leading zeros from numbers in an Excel column.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A column contains values displayed with leading zeros that should appear as ordinary numbers.
- Observed behavior
- The column displays numbers with zeros before the first significant digit.
Check whether the leading zeros are part of a custom number format or whether the values are stored as text. Do not convert identifiers such as ZIP codes if their leading zeros are significant; Excel also preserves only 15 digits of numeric precision.
Change the Excel column format to General
Use this method when leading zeros are added by the cell's number format.
Click the column letter containing the numbers with leading zeros.
On the Home tab, open the Number Format drop-down and select General.
Review the selected column. If the zeros remain, the values may be stored as text; use the text conversion method below.

Convert text values to numbers with Text to Columns
Use this method when changing the number format does not remove zeros from values stored as text.
Remove Leading Zeros in WPS Spreadsheets
Use WPS Spreadsheets to change a column's number format or convert text numbers so they display without leading zeros.
- 1. Open the workbook: Open WPS Spreadsheets and select File > Open to choose your Excel workbook.
- 2. Select the column: Click the column letter containing the values with leading zeros.
- 3. Change the format: On the Home tab, select General from the number format menu.
- 4. Convert text if needed: If zeros remain, select the affected cells and use Data > Text to Columns. Choose Delimited, clear the delimiter options, select General, and finish the wizard.

Frequently Asked Questions
Why do leading zeros remain after I select General in Excel?
The values may be stored as text. Select the affected cells and use Data > Text to Columns with General as the column data format to convert suitable values to numbers.
Will changing the number format alter the underlying value?
Changing a numeric cell's format to General changes its display, not the underlying number. Converting text to a number, however, changes the stored value.
Should I remove leading zeros from ZIP codes?
Usually not. ZIP codes and other identifiers may require leading zeros, so keep them as text or use an appropriate custom number format.
Can I convert a number with more than 15 digits in Excel?
Excel preserves only 15 digits of numeric precision. Keep longer identifiers as text rather than converting them to numbers.




