No. Excel’s CONCAT, CONCATENATE, and ampersand operator combine cell values, not their font, fill, borders, or number formats. To keep a date, currency amount, percentage, or other number looking the way you want in the combined text, use the TEXT function to specify its display format before joining it to other content.
What concatenation keeps—and what it loses
Concatenation makes a text string from values in cells or from typed text. It does not copy the source cells’ visual formatting. For example, a cell containing the number 1250 might display as $1,250.00 because it has a currency number format. The stored value is still 1250, and a formula that joins that cell to a label generally uses the value rather than reproducing the cell’s displayed currency style.
The same distinction matters for dates. Excel stores ordinary dates as serial numbers and displays them as dates because of the cell’s number format. Joining a date cell directly to text can therefore produce a serial number instead of a readable date. Fonts, cell colors, borders, alignment, and conditional formatting are also not transferred into the formula result.
This is not a malfunction or a setting that needs to be turned on. The formula returns text, and that result is a new cell value. You can apply a cell-level font, fill, or alignment to the result cell, but Excel does not automatically carry over each source cell’s formatting.
Why number formats disappear
Excel separates a value from the way it is displayed. A number format changes how a number appears in its cell without changing the underlying number. Concatenation works with the value, so it has no instruction to reproduce the source cell’s number format. The formula also cannot infer whether you want a date written as 3/15/2026, March 15, 2026, or another valid date style.
Once a formula has joined a number to text, the result is text, not a numeric value with a number format. That is useful for labels and messages, but the result will not behave like a normal number for arithmetic or sorting as a number. Keep the original numeric cells if you still need to calculate with them; use the joined text for display or export.
Preserve dates, currency, and percentages with TEXT
TEXT converts a numeric value into text using a format code you provide. Put that function around the value that needs a particular appearance, then concatenate the resulting text with labels or other cells. For instance, with a date in A2 containing March 15, 2026 and an amount of 1234.5 in B2, use:
With the date in A2 and the amount in B2, the result is “Invoice dated March 15, 2026 — total $1,234.50”:
="Invoice dated " & TEXT(A2,"mmmm d, yyyy") & " — total " & TEXT(B2,"$#,##0.00")
The format code inside TEXT controls the display in the string. In this example, mmmm spells out the month, d shows the day, yyyy shows a four-digit year, and the currency pattern adds a dollar sign and two decimal places. Excel’s display of currency symbols and separators can depend on regional settings, so check the output in the locale where the workbook will be used.
Percentages need the same treatment because a stored decimal such as 0.075 may be displayed as 7.5% in its source cell. With the decimal value 0.075 in C2, this formula returns “7.5% increase”:
=TEXT(C2,"0.0%") & " increase"
You can also control decimal places, date punctuation, and other display details in the format code. If a number must show leading zeros, use a format pattern with zero placeholders. With the number 123 in A2, this returns the five-character text value 00123:
=TEXT(A2,"00000")
TEXT is especially useful when a combined string is meant for a report heading, notification, or printable sentence. It is not a replacement for the source number’s formatting: it creates formatted text for this particular output.
Build a combined value step by step
For a short combination, the ampersand (&) operator is easy to read and works in current Excel versions. Type text inside straight double quotation marks, and put an ampersand between each text item or cell reference. Add spaces or punctuation as quoted text where they belong. A frequent source of confusing output is forgetting that Excel will not insert spaces automatically.
For example, with a first name in A2 and a last name in B2, this expression places one space between them:
=A2 & " " & B2
When joining several cells, CONCAT or TEXTJOIN can make the formula more convenient. CONCAT joins values but does not apply source formatting. TEXTJOIN can insert a chosen delimiter and can optionally ignore empty cells. With values in A2:C2, this joins nonblank entries with a comma and a space:
=TEXTJOIN(", ",TRUE,A2:C2)
That formula still does not preserve number formats. If one of the cells is a date or amount, wrap that value in TEXT with the desired format code before combining it. For a compact expression, the ampersand operator is often easiest to adapt; for a list of cells with a repeated separator, TEXTJOIN is often clearer.
Format the result cell separately
There are two different formatting jobs to consider. TEXT controls how numbers and dates appear inside the text string. Cell formatting controls the appearance of the result cell as a whole—for example, its font, fill color, borders, alignment, or text wrapping. You can set those cell-level styles on the formula cell without changing the formula.
In Excel for Microsoft 365 on Windows, select the result cell and use the formatting controls on the Home tab. You can also copy a source cell’s format using Format Painter, but doing so applies a cell style to the destination; it does not make the formula inherit formatting for individual pieces of its text. The formula result remains one text value, even if the entire result cell is bold or colored.
A formula does not provide a way to assign one font or color to one segment and another style to a different segment. If a report needs rich text with differently styled words, consider placing the pieces in separate cells and formatting those cells, or use a carefully managed manual or VBA approach when a single-cell result is essential. A formula alone will not encode those character-level styles.
Choose the right workflow for your goal
The best method depends on whether you need a live result, a one-time text value, or a visually formatted report. Consider these common cases:
- Live label or sentence: Use a formula and TEXT for any date, percentage, or number whose display matters. The result updates when its source values change.
- One-time output: Create the formula result, then copy it and use Paste Values if you want to replace the formula with its current text. This does not restore the source cells’ visual styling.
- Numeric calculations: Keep amounts and dates in their original cells and use a separate display formula. A concatenated result is text, so do not use it as the numeric input for later calculations.
- Different styling within one sentence: Use separate cells or another method designed for rich text. Do not expect CONCAT, CONCATENATE, or TEXTJOIN to carry font or color choices from the source cells.
These distinctions also help when preparing data for email, labels, or a text file. A displayed number format is not necessarily part of the underlying data. If the recipient needs a precise character string—such as a date in a fixed format—create that string explicitly rather than relying on how a cell happens to look on your screen.
Common problems and how to fix them
- A date appears as a number: The formula is using the date’s stored serial value. Wrap the date reference in TEXT and specify the date pattern you want.
- A currency amount loses its symbol or decimals: Add TEXT around the amount and include the desired currency symbol and decimal places in its format code.
- Words run together: Add a quoted space, such as
" ", between references. Excel does not infer spacing from how the cells look. - A percentage looks too small: The stored value may be a decimal such as 0.075. Use a percentage format code in TEXT to display it as 7.5%.
- Leading zeros vanish: Excel treats the value as a number, and concatenation uses the numeric value. Use TEXT with zero placeholders, or store an identifier as text if it is not meant for arithmetic.
Be deliberate with rounding, too. A number format can display fewer decimal places than a value actually contains. If the combined sentence must show a fixed number of decimal places, specify that in TEXT; the displayed string will then reflect the chosen precision, while the source value remains unchanged. For business or scientific outputs, choose a precision that suits the purpose rather than assuming the cell’s existing appearance will carry across.
Frequently Asked Questions
Can CONCAT keep bold, font color, or cell fill?
No. CONCAT joins values into text and does not copy font, color, fill, borders, or other source-cell styles. Apply a style to the result cell separately, or use a different workflow if portions of the text need different styles.
How do I concatenate a date without getting a serial number?
Wrap the date reference in TEXT and choose a date format, such as a month name and four-digit year. This converts the date into the readable text you specify before it is joined to other content.
Does TEXT change the original number or date?
No. TEXT creates a formatted text result for the formula. The original cell remains unchanged and can still be used in calculations.
Is CONCATENATE different from CONCAT for formatting?
No. Both combine values as text and neither inherits cell formatting. CONCAT is the newer function name; the ampersand operator is another way to join values.
Can I keep the result as a number after concatenating?
A string that includes labels or other text is text, not a numeric value. Keep the original number in a separate cell for calculations and use the concatenated result only where text is needed.
Will the same formula work in Excel for Mac or the web?
The ampersand, CONCAT, TEXT, and TEXTJOIN formula behavior is generally the same in current Excel for Microsoft 365 on Windows, Mac, and the web. Ribbon locations and paste options can differ by platform, but the formulas do not preserve source-cell formatting on any of them.
Related
- How to Zoom in Microsoft Excel: Quick Ways to Resize
- Excel Zoom: How to Enlarge a Worksheet on Windows PC
- Google Sheets Zoom: How to Enlarge Your Spreadsheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create Multiple Address Labels in Microsoft WordTo create multiple address labels in Word, set up a recipient list, choose the label stock you have,…
- Excel Named Range Scope: Workbook vs. Worksheet NamesIn Excel, a named range’s scope determines where its name can be used: a workbook-scoped name is available…
- How to Put Strikethrough in Excel with Shortcuts and MenusTo put strikethrough in Excel for Microsoft 365 on Windows, select the cell or cells and press Ctrl+5;…
- How to Create a Signature to Insert in Microsoft WordTo create a reusable handwritten signature in Microsoft Word, sign your name on plain white paper, save a…
- How to Average Data in Excel Across Different SheetsTo average the same cell across several worksheets, enter a formula such as =AVERAGE(Jan:Mar!B2) when the sheets are…
- How to Sort a Range by Date in Google Sheets: StepsTo sort a range by date in Google Sheets, select the entire table, open Data > Sort range…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.