Add Text to an Excel Number Format Without Changing Values

How-to basics · Updated November 19, 2026

To add text to a number’s display in Excel without changing the value, apply a custom number format: select the cells, press Ctrl+1, choose Custom, and enter a format such as 0" units". The cell will show a number followed by “ units,” while Excel still stores and calculates with the original number.

Apply a custom format in Excel

In Microsoft Excel for Microsoft 365 on Windows, select the cells you want to format and open the Format Cells dialog with Ctrl+1. On a Mac, Command+1 opens the corresponding dialog. Then:

  1. Choose the Number tab, if it is not already selected.
  2. Select Custom in the Category list.
  3. Click the Type box, enter the format code, and check the sample shown in the dialog.
  4. Choose OK to apply it.

For example, enter 0" items" to display 12 as “12 items.” The value remains 12, not a text string. You can also open the dialog from the Home tab’s Number group using its dialog box launcher. To reuse a format, select another cell and choose it from the Custom list; formats used in a workbook are available there.

To remove the custom display, reopen Format Cells and choose General or another number category. This changes the appearance, not the stored value. If the cell contains text rather than a number, a numeric format may not produce the result you expect; see the text-format section below.

How custom number formats work

A custom number format is a set of display instructions. It can control such details as decimal places, separators, signs, and literal words or symbols. Text that should appear exactly as typed is usually enclosed in double quotation marks in the format code. For instance, 0" kg" displays 2.5 as “2.5 kg.” The quotes mark “ kg” as literal text; they are not displayed.

Common format symbols include:

  • 0 displays a digit and adds zeroes when needed. For example, 000 can show 7 as 007.
  • # displays a digit when one is present but does not force an extra zero.
  • ? can reserve space for insignificant zeroes to help align values.
  • . marks the decimal position, and a comma can group thousands or scale a number when used in the relevant position.
  • @ is a placeholder for text in a text section of a custom format.

Use quotes for words and phrases, including spaces: 0" tickets sold". Some characters can also be entered as literal characters, but quoting a label makes its purpose clear and helps avoid characters being interpreted as format instructions. A custom format changes what Excel shows in the cell; the formula bar and calculations continue to use the underlying value.

Useful examples for labels, units, and codes

Choose a format that matches the kind of value and the way readers should interpret it. These examples assume the cells contain numeric values unless noted:

  • 0" files" displays 18 as “18 files.” It rounds the display to a whole number; it does not round the stored value.
  • 0.0" cm" displays 3.46 as “3.5 cm.” Use 0.00" cm" if two displayed decimal places are important.
  • "Order "0000 displays the numeric value 23 as “Order 0023.” The zeroes are padding in the display, not part of the value.
  • +#,##0;-#,##0;0 displays positive values with a plus sign and negative values with a minus sign. It does not add a label, but demonstrates how separate sections can tailor the display by sign.
  • mmm d, yyyy" (reported)" can append a note to a date display, provided the cell contains a valid Excel date value.
  • 0% displays 0.25 as 25%. Adding a literal such as 0%" complete" displays “25% complete.”

Consider whether a label could make a value misleading. Formatting 0.25 as a percentage means 25%, not 0.25%; the percent sign in a number format scales the displayed number. Likewise, a value displayed with no decimal places may still contain fractional precision that affects later calculations.

Use format sections for positive, negative, zero, and text

A custom format can contain up to four sections separated by semicolons. In order, they apply to positive numbers, negative numbers, zero, and text. For example, 0" units";-0" units";"none";@ shows positive values with “ units,” negative values with a minus sign and the same label, zero as “none,” and text as entered.

You do not have to provide all four sections. With one section, the same number pattern generally applies to all numbers. With two sections, the first is for positive numbers and zero, and the second is for negative numbers. With three, the sections are for positive, negative, and zero values. A fourth section, when present, handles text. Because section order matters, a semicolon in a format code is not simply decorative punctuation: it separates rules.

Sections are helpful when a report needs a special zero label, but use them carefully. Showing a zero as “none” is a display choice, not proof that data is missing. If a zero means a measured result, “0” or “0 units” may be clearer. A blank cell and a cell containing zero are different in Excel even if a custom format hides or disguises that distinction.

Adding text to actual text cells

Custom number formats are most useful for numbers, dates, and times. If a cell already contains text such as “North,” a numeric pattern like 0" units" cannot turn that word into a number or reliably append a label to it. In a four-section format, @ represents the cell’s text in the text section. For example, 0" units";-0" units";"none";@" (reviewed)" displays text followed by “ (reviewed)” while leaving the text itself unchanged.

For a one-off label, typing it directly into a cell may be simpler. If you need a new text value built from a value in another cell, a formula can do that, but its result is text rather than a numeric value. With the number 1250 in A2, enter =TEXT(A2,"#,##0")&" units" in another cell; it returns “1,250 units.” The TEXT function converts the value to text according to the specified format, and the ampersand joins that text with the label. Use a custom number format instead when the result must remain usable as a number for arithmetic, sorting, or charting.

Custom formats versus changing the cell value

The key choice is whether the added words are only for presentation or should become part of the data. If a column contains quantities that need to be summed, filtered numerically, or used in calculations, keep them numeric and apply a custom format. A cell displaying “18 files” can still contribute the numeric value 18 to a sum. This is often the best choice for tables with consistent units or labels.

By contrast, concatenating a label with a number using a formula, or entering the entire phrase as text, creates text. Text is appropriate for a finished sentence, a printable identifier, or a descriptive field, but it is not the same as a numeric quantity. It may not sort or calculate like a number, and formulas that expect numbers may need additional conversion. Avoid adding units directly into every numeric entry if those cells will later feed calculations; store the number and, where useful, the unit separately or apply a format.

One common misconception is that a format such as 00000 changes 42 into the stored text “00042.” It does not: it displays leading zeroes while the value remains numeric 42. If an identifier’s leading zeroes are essential data—for example, a code that must be preserved exactly when exported—store it as text or import it as text. Number formatting is a presentation layer, not a data-conversion tool.

Common problems and how to fix them

  • The label does not appear. Confirm that you applied the format to the intended cells, chose Custom, and placed the literal text in quotation marks. Check the sample in Format Cells before accepting.
  • The cell shows the format code itself. The entry may have been typed into the worksheet instead of the Type box, or the cell may be treated as text. Open Format Cells again and enter the code in the Type field.
  • The display rounds unexpectedly. The number of zero placeholders after the decimal point controls displayed precision. Use 0.00" kg" to show two decimal places. The underlying value is not rounded by this display setting.
  • Negative values or zero look wrong. Review the semicolon-separated sections and their order. A zero-specific third section can replace the ordinary numeric display, while a negative section can omit a minus sign if it is written without one.
  • A date or percentage seems incorrect. Excel stores dates as serial values and percentages as numeric values. The format changes their interpretation on screen; verify that the underlying cell contains the intended date or decimal before choosing a display pattern.
  • The code behaves differently on another computer. Regional settings can affect number and date conventions, including separators and date order. If a workbook is shared internationally, check the display on the recipient’s Excel version and locale.

Excel desktop, Mac, and web considerations

The steps above target Excel for Microsoft 365 on Windows. On Mac, select the cells and use Command+1 to open Format Cells; the dialog’s layout can differ, but the Number and Custom choices serve the same purpose. Keyboard settings or hardware can affect shortcuts, so the dialog can also be opened through Excel’s formatting controls.

Excel for the web may display custom formats already saved in a workbook, but its available controls can differ from the desktop application. If you need to create or edit a detailed custom format and cannot find the needed Type field in the web interface, open the workbook in desktop Excel and use Format Cells. When sharing a workbook, remember that a custom format travels with the cell formatting, while the value remains available to calculations.

Frequently Asked Questions

Can I add words to a number in Excel without changing its value?
Yes. Apply a custom number format such as 0" boxes". Excel displays the word beside the number but keeps the cell numeric.

How do I add a prefix before a number?
Put the prefix in quotation marks before the numeric placeholders. For example, "ID-"0000 displays 23 as “ID-0023” while retaining numeric 23.

Can a custom format append text to a text cell?
Yes, by using @ in the text section of a format. A format with four sections can include a final text rule such as @" checked". For simple text manipulation, a formula may be more straightforward.

Will adding text with a number format affect sums or formulas?
No. A custom format changes the display, not the value, so numeric calculations continue to use the underlying number. A formula that joins a label to a number, however, returns text.

How do I remove text added by a custom format?
Open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then choose General or another appropriate number format. The stored value remains unchanged.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.