Excel Custom Number Format: Add Text at the Far Left

Formulas & functions · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, use a custom number format with an asterisk followed by a space: "Status:"* #,##0.00. The label appears at the left edge of the cell while the numeric value stays at the right; the value remains a number you can calculate with.

What “far left” means in a number format

There are two different things people may mean by putting text before a number. A simple prefix, such as “Status: 125,” places words immediately before the digits. A far-left label is separated from the digits so it sits at the left side of the cell, with the number at the right. A regular prefix format does the first, but not necessarily the second.

Excel’s custom format fill character, the asterisk (*), provides the gap. It repeats the character immediately after it until the cell’s available width is filled. In the example above, the repeated character is a space. The result resembles an accounting-style display: a label on one side and an amount on the other.

This changes only how a numeric value looks. It does not add words to the stored value, create a second value, or change the cell’s underlying number. That distinction matters if you intend to sort, total, chart, or use the cell in a formula.

Apply a left label and right-aligned number

  1. Select the numeric cells you want to format.
  2. Press Ctrl+1 on Windows to open Format Cells. On a Mac, use Command+1.
  3. Choose the Number tab, then select Custom.
  4. Enter "Status:"* #,##0.00 in the Type box. Replace Status: with your own label and adjust the number pattern as needed.
  5. Choose OK. Widen the column if the label and number do not both fit.

The number pattern #,##0.00 displays thousands separators and two decimal places. For example, a stored value of 1250.5 displays as the label at the left and 1,250.50 at the right, with spaces filling the gap. The cell still contains 1250.5, not the displayed text.

Keep the cell’s horizontal alignment set to General or Right for the usual result. Center alignment can make the display look less like a label-and-amount layout. If your workbook has existing alignment settings, check the result after applying the format; number format and alignment are separate cell settings.

How the custom format code works

Each part of the code has a separate job. Quotation marks make Status: literal text rather than a number-format instruction. The asterisk tells Excel to repeat the next character. The space immediately after the asterisk is the character that gets repeated. Finally, #,##0.00 tells Excel how to show the number.

  • "Due:"* mmm d, yyyy can put a literal Due: label at the left and display a date at the right, provided the cell contains a valid Excel date serial number.
  • "Rate:"* 0.0% displays a percentage with one decimal place. A stored value of 0.125 displays as 12.5%.
  • "Items:"* #,##0 displays a whole-number count with a thousands separator.
  • "Weight:"* 0.0" kg" adds a unit after the number while the Weight: label stays at the left.

These examples illustrate display formats, not changes to the stored values. For instance, the percentage example does not convert 0.125 into a different stored number; Excel simply displays it as a percentage.

Keep the value numeric

A custom number format is useful when the label is a visual cue and calculations still matter. You can use a cell formatted this way in a SUM calculation, sort it as a number, or create a chart from it. The visible label is not part of the value Excel uses in those operations.

That behavior differs from joining a label and a number into text with a formula or typing both into the cell. A text result may look right, but it is no longer a plain numeric entry for many spreadsheet tasks. If you need the label to travel with the value when copying data into another program, exporting a report, or printing values only, a custom format may not be enough: some destinations use the underlying value rather than Excel’s display format.

Custom formats also apply to selected cells, not automatically to every future entry in a column. To carry the appearance into new rows, format the intended range in advance, copy formatting, or use an Excel table and check how its new rows inherit formatting.

Choosing decimals, dates, and units

Choose the part after the asterisk to suit the value and the people reading it. Use 0 when a digit should always appear, and # when an insignificant digit can be omitted. A comma can group thousands, while decimal places determine how much precision is displayed. A format can round the visible result without rounding the stored value.

Dates require particular care because Excel stores dates as serial numbers. A date format such as mmm d, yyyy displays a recognizable date only when the cell contains a date value; applying that format to an ordinary count can make the count appear as an unexpected date. Likewise, adding a unit such as kg or pcs to a number changes its appearance, not its unit or measurement.

For currencies, consider whether the symbol belongs next to the number or at the far edge. A simple currency prefix can use a quoted symbol, while a left-edge label with a right-edge amount can use the fill character. If you need different currency symbols, decimal places, or accounting conventions, choose a format that matches the workbook’s requirements rather than assuming one pattern suits every currency.

Negative numbers, zeros, and text entries

Excel custom formats can contain sections separated by semicolons: positive numbers; negative numbers; zero; and text. A format with one section applies that pattern to numeric values generally; adding more sections lets you give negative values or zeros a different appearance. For example, an organization might want negatives in parentheses or zeros shown as a dash. Build and preview those sections carefully, because the placement of the label, parentheses, minus sign, and repeated spaces all affect the result.

For a simple label, start with one section and check both positive and negative sample values. If you later add separate sections, repeat the label and fill-character pattern wherever you want it to appear. A section that omits a label or uses a different number pattern can make the column look inconsistent.

Text stored in a cell is not converted into a number by this format. The fourth custom-format section can control how text is displayed, typically using the @ placeholder, but the numeric pattern itself does not turn words such as “Pending” into numeric values. If a column mixes numbers, dates, and words, test each kind of entry and consider whether a single format is appropriate.

Common problems and fixes

  • The label is beside the number, not at the edge. Check that the code contains an asterisk followed by a space: "Status:"* #,##0. A format such as "Status: "#,##0 inserts only a normal prefix.
  • The display is cramped or shows hash marks. Make the column wider. The label, number, and repeated spaces all need room; Excel cannot create space beyond the cell width.
  • The label repeats instead of a gap appearing. The asterisk repeats the next character exactly. If the character after * is a letter or punctuation mark rather than a space, Excel repeats that character.
  • The format does not affect the entry. Confirm that the cell contains a number or date rather than text that looks like one. Number formats do not convert text values into numbers.
  • The result changes after copying or exporting. The format controls Excel’s display, and another app or export process may not preserve it. Check the destination if the left label is essential to the final output.

When to use a separate label cell instead

A custom format is compact when the label is short, consistent, and purely presentational. Use a separate column or cell when labels vary row by row, need their own formatting, should be included in exported data, or must remain independently editable. For example, a table with a Category column and an Amount column is often easier to filter and analyze than a single amount cell carrying a label in its number format.

A separate label cell also gives you more control over alignment and accessibility. Screen readers, data imports, and downstream tools may expose the stored number rather than the custom display. If a reader must receive the label as actual content, store it in its own cell or use an appropriate text-based report layout.

For a printed report, another option is to put labels in one column and values in the next, then adjust column widths and alignment. This is less compact than a custom format, but it is transparent to other spreadsheet users and does not rely on them understanding Excel’s format code.

Frequently Asked Questions

Can I put text at the far left and keep the number at the right?
Yes. Use a quoted label, an asterisk, and a space before the number pattern, such as "Total:"* #,##0.00. The asterisk repeats spaces to fill the available width.

What is the difference between a quoted prefix and an asterisk?
A quoted prefix displays text immediately before the formatted number. The asterisk repeats the next character to fill available cell width, which creates the gap needed to separate a left-side label from the number.

Will the custom format change my value into text?
No. A number format changes how a numeric value looks, not the value stored in the cell. The number remains available for calculations and numeric sorting.

Why does my label not reach the left edge?
Check that the code includes * —an asterisk followed by a space—and that the cell is not center-aligned. Also widen the column if the label and number leave too little room for the fill spaces.

Can I use this with a percentage or date?
Yes, if the cell contains the appropriate numeric value. Put a percentage pattern such as 0.0% or a date pattern such as mmm d, yyyy after the fill character and space.

Does the format work in Excel for the web?
Custom number-format editing and display can differ from desktop Excel. The steps above are for Excel for Microsoft 365 on Windows; if the web app does not offer the needed custom format controls, open the workbook in desktop Excel and apply the format there.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.