Display Text with a Numeric Value in Excel Calculations
Question details
Display a descriptive label alongside a number while retaining the numeric value for calculations.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A cell containing 2.4 should display a label such as car medium without converting the value to text.
- Observed behavior
- The cell displays the label and number, while formulas use the underlying numeric value.
Enter the value as a number, such as 2.4, rather than typing the label into the cell. Select the cell or range where you want the label to appear.
Add a Label with an Excel Custom Number Format
Use a custom format to show the same descriptive label beside numeric values without changing the values used in formulas.
Type 2.4 into cell A1 and press Enter.
Right-click A1, select Format Cells, and open the Number tab.
Select Custom, enter "'car medium' = "0.0 in the Type box, and click OK. The cell displays 'car medium' = 2.4.
In another cell, enter =A1*4. The result is 9.6 because A1 still contains the number 2.4.

Display a Text Label with a Numeric Value in WPS Spreadsheets
Use a custom number format in WPS Spreadsheets to display a label beside a number while keeping the cell usable in formulas.
- 1. Enter a numeric value: Open a workbook in WPS Spreadsheets, type 2.4 in cell A1, and press Enter.
- 2. Open the format dialog: Right-click A1 and select Format Cells.
- 3. Set the custom format: On the Number tab, select Custom and enter "'car medium' = "0.0 in the Type box. Click OK.
- 4. Calculate with the cell: Enter =A1*4 in another cell to calculate 9.6 using the underlying numeric value.

Frequently Asked Questions
Does the label become part of the cell value?
No. A custom number format changes the display only. Select the cell and check the formula bar to see the underlying numeric value.
How can I change the displayed label?
Right-click the cell, select Format Cells, and choose Number > Custom. Replace the text inside the double quotes in the Type box with your preferred label.
Can I show more than one decimal place?
Yes. In Format Cells > Number > Custom, use 0.00 instead of 0.0 to display two decimal places. The underlying value remains unchanged.
Why does my formula return an error after I type the label and number together?
Typing a label directly into the cell can make the entry text rather than a number. Enter the number alone, then add the label through Format Cells > Number > Custom.




