Formatting Issues

Remove Leading Zeros from a Number Column in Excel

Nimra MalikNimra Malik Nov 14, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

Change the Excel column format to General

Use this method when leading zeros are added by the cell's number format.

1
Select the column

Click the column letter containing the numbers with leading zeros.

2
Apply General format

On the Home tab, open the Number Format drop-down and select General.

3
Check the values

Review the selected column. If the zeros remain, the values may be stored as text; use the text conversion method below.

Change the Excel column format to General
Work with numbers in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and select File > Open to choose your Excel workbook.
  2. 2. Select the column: Click the column letter containing the values with leading zeros.
  3. 3. Change the format: On the Home tab, select General from the number format menu.
  4. 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.
Remove formatting-based leading zeros with the General number format.Convert suitable text numbers using Text to Columns.Open and edit Microsoft Excel XLS and XLSX files.Work in a familiar spreadsheet interface.
microsoft office alternative - wps office

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.