If you want to resolve the issue just within the workbook because it's not used by other programs as a data source, you can use a custom or a special format to keep the leading zeros.

Formatting numbers to keep the leading zeros isn’t supported in Web Excel. Learn more about using Excel desktop application to do this.

If your sheet contains zero values or contains calculations that produce zero values, you can hide the values or use formatting options to change how the values will display.

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

The TRIMRANGE function excludes all empty rows and/or columns from the outer edges of a range or array. Syntax The TRIMRANGE function scans in from the edges of a range or array until it finds a …

You can use the TRIM function to remove any leading or trailing spaces. The following example uses TRIM nested inside a VLOOKUP function to remove the leading spaces from the names in A2:A7 …

You can prevent this automatic number formatting by applying the Text format to the cells. It's easy to do: Select the cells that contain numbers you don't want Excel to automatically format. Select …

You can prevent this automatic number formatting by applying the Text format to the cells. It's easy to do: Select the cells that contain numbers you don't want Excel to automatically format. Select …

When that happens, Excel retains the value from the last successful calculation. If you suspect you have a circular reference in a cell that isn't showing a zero, try this: Select the formula in the formula bar, …

This example uses the LTrim function to strip leading spaces and the RTrim function to strip trailing spaces from a string variable. It uses the Trim function to strip both types of spaces.