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”).

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.