---
url: /modelling-guides/creating-a-revenue-model/number-formatting.md
description: Double Click on the highlighted cell and remove existing instructions.
---

# Number Formatting

Double Click on the highlighted cell and remove existing instructions. Then set up the formatting as shown in the screenshot.

We have a bunch of measures which all need different number formatting within this workview, for instance, units should be displayed as a whole number and margin as a percentage. We can use set instructions to add basic number formatting to groups of measures. The instruction Ignore new formatting on prior members acts as a break between different formats and allows us to use a number of different number formats within a single set.

![Number Formatting](/revenue-model-figures/nf-stationmaster-formatting.png)

On the same set, add Margin % and then choose Format 0.00% for percentage values.

Now we can see that the values are all nicely formatted!

![Formatted Values](/revenue-model-figures/nf-formatted-values.png)

We can bring in the remaining Product Brands similarly if required. The formula wouldn't need to be defined again, as we didn't restrict it.

![Adding Other Products by Brand](/revenue-model-figures/nf-adding-other-products-by-brand.png)

At the bottom, we will add All Products by Brand to get an overview. Add a row to the bottom and then double click on the cell, add a blank space, then select All Products by Brand and add it to the set.

![Adding All Products](/revenue-model-figures/nf-adding-all-products.png)

Just like we did it earlier, we will be adding Measures and format them. We will save this workview as Sales Planning by Product

![Set Instructions](/revenue-model-figures/nf-measure-set-instructions.png)