Example
37.5% / 100 = 0.375. Decimal form is often needed before multiplying a rate by a quantity.
Use case
Financial rates, discounts, tax rates and statistical proportions are often entered as percents by users but used as decimals in formulas.
Common mistakes
Do not enter both the percent sign and a decimal version of the same number. For example, 7.5% becomes 0.075, not 0.75.
When to convert back
If a formula result is 0.18 and you want to show it as a percent, multiply by 100 to get 18%.
Last reviewed: 2026-05-17