Percentage

Technical Articles > Formatting Text by using Number Formats

A character with special meaning is the percentage symbol. In combination with one or more placeholders, the calculated formula value is multiplied by 100 and shown together with the percentage symbol.

Examples:
Formatting 0.52 with #% will be displayed as 52%.
Formatting 1 with #% will be displayed as 100%.
Formatting 0.00321 with 0.##% will be displayed as 0.32%.
Formatting 0.52 with %# will be displayed as %52.