Formatting Issues

Display Text with a Numeric Value in Excel Calculations

Amos GikundaAmos Gikunda Nov 18, 2026 871 views

Question details

Display a descriptive label alongside a number while retaining the numeric value for calculations.

Display Text with a Numeric Value in Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the number

Type 2.4 into cell A1 and press Enter.

2
Open number formatting

Right-click A1, select Format Cells, and open the Number tab.

3
Apply the custom format

Select Custom, enter "'car medium' = "0.0 in the Type box, and click OK. The cell displays 'car medium' = 2.4.

4
Use the value in a formula

In another cell, enter =A1*4. The result is 9.6 because A1 still contains the number 2.4.

Add a Label with an Excel Custom Number Format
Display precision: The 0.0 format displays one decimal place. It does not change the underlying value used in calculations.
Format numeric values in WPS Spreadsheets

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. 1. Enter a numeric value: Open a workbook in WPS Spreadsheets, type 2.4 in cell A1, and press Enter.
  2. 2. Open the format dialog: Right-click A1 and select Format Cells.
  3. 3. Set the custom format: On the Number tab, select Custom and enter "'car medium' = "0.0 in the Type box. Click OK.
  4. 4. Calculate with the cell: Enter =A1*4 in another cell to calculate 9.6 using the underlying numeric value.
Show descriptive labels without converting numbers to textKeep numeric values available for spreadsheet calculationsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for formatting cells
microsoft office alternative - wps office

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.