How to remove leading zeros in excel


Staff member
How to Remove Leading Zeros from Numbers
  1. Select the numbers from which you want to remove the leading zeros. You will notice that there is a yellow icon at the top right part of the selection.
  2. Click on the yellow error checking icon.
  3. Click on 'Convert to Number'