Microsoft Excel Tutorial: Formula To Show Word Next To Discount Percentage. How to Show “Discount 10%” in Excel Using Formulas & Custom Formatting.

Today’s question comes from Roo: How can we modify a dropdown list of discount percentages (10%, 20%, 30%) to display as “Discount 10%” on an invoice? This video covers multiple ways to achieve this, whether your percentages are stored as text or numbers.

First, we look at a simple formula approach. By using a basic concatenation formula with an ampersand (`&`), we can combine the word “Discount” with the selected percentage. However, if your percentages are stored as actual numbers, you’ll need to use the `TEXT` function to properly format them.

But wait—there’s an even better way! Instead of using a formula, you can leverage Excel’s **Custom Number Formatting**. This trick allows you to keep the numbers functional while displaying them exactly how you want—without extra formulas or helper cells. Just modify the number format to include “Discount” before the percentage, and Excel does the rest.

This method keeps your data clean, prevents formula errors, and makes calculations like summing the discounts work seamlessly. It’s a powerful Excel trick that saves time and reduces complexity.

If you found this tip useful, hit **LIKE**, **SUBSCRIBE**, and leave a comment with your Excel questions. Thanks to Roo for the great question—see you in the next episode of **MrExcel**!

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Problem Statement: Show the word “Discount” next to number
(0:30) If the list is Text percentages
(1:02) Formula to Concatenate “Discount ” with the number
(1:26) The math still works with text percentages
(1:50) If your validation list is numeric
(2:04) Using TEXT function to format as percentage
(2:34) Using Custom Number Format to add words to a number
(4:05) Wrap up

This video answers these questions:
Excel dropdown list with text and percentage
How to show “Discount 10%” in Excel
Excel formula to add text to a number
Custom number formatting in Excel
Apply discount percentage in Excel invoice
Concatenate text and percentage in Excel
Excel TEXT function for formatting numbers
Best way to format discount percentages in Excel
Data validation dropdown with formatted text in Excel
Excel tricks for displaying numbers with labels