Numbers such as 1, 10, and 100 can be displayed as 001, 010, and 100 in Excel either by applying custom formatting (visual only) or by converting them to text values that contain leading zeros. Method 1: Custom number format (visual only) This method changes how numbers are displayed while preserving their numeric nature for calculations. Select the relevant cells….