Formatting raw data in Google Sheets usually involves highlighting a column of numbers and clicking the “%” button on the toolbar. While this works perfectly for static data, it becomes highly problematic when you are building dynamic dashboards or using complex text-concatenation formulas. If you pull a decimal value like 0.75 into a text string, the formatting is lost, and it displays as “0.75” instead of “75%”. To force the number to behave like a formatted percentage directly within a formula, you need to use the TO_PERCENT function.
What Does the TO_PERCENT Function Do?
The TO_PERCENT function is a specialized formatting formula. It takes a standard numerical value or a cell reference, multiplies it by 100, and permanently affixes a percentage sign to the output. Crucially, it changes the underlying data type of the cell output, ensuring that subsequent formulas or charts recognize the result as a strict percentage rather than a floating-point decimal.
Understanding the Syntax
The syntax is incredibly simple, requiring only a single argument:
=TO_PERCENT(value)
The value can be a hard-coded number, a reference to another cell, or an entirely nested mathematical formula.
Basic Percentage Conversion
If you have an unformatted decimal value in your spreadsheet, you can instantly convert it without touching the toolbar.
- Open your Google Sheets document.
- Assume cell A1 contains the raw decimal 0.824.
- Click on cell B1.
- Type the following formula:
=TO_PERCENT(A1)
- Press Enter.
Cell B1 will immediately display 82.4%. The function automatically handles the multiplication and applies the correct symbol.
Using TO_PERCENT Inside Text Strings
The most powerful use case for this function is combining dynamic mathematics with descriptive text using the concatenation operator (&). If you calculate a profit margin and try to merge it with text without formatting, the result is ugly and unprofessional.
For example, if you divide your Profit by your Revenue (e.g., 500/2000), the raw result is 0.25. If you write the formula:
="Your profit margin is " & (500/2000)
The sheet will output: Your profit margin is 0.25.
By wrapping the mathematical portion of the formula inside the TO_PERCENT function, you force the spreadsheet to format the calculation before it merges with the text string.
="Your profit margin is " & TO_PERCENT(500/2000)
This updated formula will output a perfectly clean, professional sentence: Your profit margin is 25%. Because the formatting is baked directly into the formula, if your underlying revenue numbers change, the percentage string will update automatically without requiring manual re-formatting.