Excel Guides

Using Slashed Zeroes in Excel

Slashed zeroes are used in Excel to help align numbers. When you format a number with a slash (/) through the zero, it tells Excel to keep the zero in the number.

This is helpful when you want to line up numbers that have different decimal places. For example, if you have a column of numbers that go from 100 to 1,000, and you want to format them so they all take up the same amount of space, you can use slashed zeroes.

To format a number with a slash through the zero:

  1. Select the cells you want to format.
  2. On the Home tab, in the Number group, click the Decrease Decimal button twice.
  3. On the Home tab, in the Number group, click the Increase Decimal button once.

The numbers will now have a slash through the zeroes and will be aligned properly.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.