Here are the multiple methods using which you can keep the leading zeros that are automatically omitted before a number in an Excel workbook.

In this Excel tutorial, I’ll show you how to implement a setting, a format or a function solution to hide or suppress zeros.

Replace zeros with NA () The most permanent fix for hiding zeros is to replace literal zero values with the NA () function using Excel’s Find and Replace feature.