How to create a custom number format in Excel

Let’s take a look.

In this case, the currency format is a good start.

Now, when we click OK, we see we’re getting close.

To actually create our custom format, we need to revisit the Format Cells dialog.

This time, we start by selecting Custom.

This will immediately create a new custom format, based on currency, that we can further customize.

The semicolon separates the format for positive numbers on the left from negative numbers on the right.

When we click OK, we see the format we’re after.

If we modify any values, we see our format displays the new values properly.

New custom formats will appear at the bottom of the Custom format list.

Every time you change your custom format, Excel will save a new version.

Use the delete button to remove custom formats you no longer need.