To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).

Open your spreadsheet in Microsoft Excel. Click and drag your mouse across the cells you want formatted without leading zeros. Right-click any selected cell and choose "Format Cells." ...