How to Remove Trailing Zeros in Excel (With Example)

You can use the following formula in Excel to remove trailing zeros from numbers:


This particular formula removes all trailing zeros from the number in cell A2.

For example, if cell A2 contains 104000 then this formula will return 104.

Note that any zeros within the number (and not trailing at the end) will be left in the number.

The following example shows how to use this formula in practice.

Example: How to Remove Trailing Zeros in Excel

Suppose we have the following column of numbers in Excel:

Notice that all of the numbers have at least one trailing zero.

Suppose we would like to remove the trailing zeros from each number.

We can type the following formula into cell B2 to do so:


We can then click and drag this formula down to each remaining cell in column B:

Excel remove trailing zeros

Notice that column B displays each corresponding value in column B with the trailing zeros removed.

For example:

  • 104000 becomes 104.
  • 540000000 becomes 54.
  • 30050 becomes 3005.
  • 120000000 becomes 12.

And so on.

All trailing zeros from each number have been removed.

Note: If a number has no trailing zeros, then this formula will simply return the number itself.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Concatenate Values and Keep Leading Zeros
Excel: How to Remove Specific Text from Cells
Excel: How to Delete Rows with Specific Text

Leave a Reply

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