How to add trailing zeros in excel

Adding trailing zeroes in Excel is a useful way to make data easier to read and interpret. In this article, we will provide a step-by-step guide on how to add trailing zeros in Excel with an example.

Step 1: Open your Excel Workbook and select the cells that you want to add trailing zeros to.

Step 2: Select the “Number” tab from the ribbon at the top, then select “More Number Formats” from the drop-down menu.

Step 3: Select “Custom” from the Category list.

Step 4: In the Type field, enter “#,##0.00” and click “OK”.

Step 5: Your data will now be formatted with trailing zeros, like this:


Before Formatting:


After Formatting:


That’s it! You’ve successfully added trailing zeros to your data in Excel. This technique can be used to make data easier to understand and interpret.

Leave a comment

Your email address will not be published. Required fields are marked *