Formula Errors

Fix Excel #VALUE! Errors When Formatting Dates with TEXT

John WilsonJohn Wilson Nov 18, 2026 870 views

Question details

The user needs to combine text, a formatted date, and another cell value without an Excel #VALUE! error.

Fix Excel #VALUE! Errors When Formatting Dates with TEXT
Product
Microsoft Excel
Device & OS
not provided
Scenario
A formula combines a label, the date in CashCount!C1, and the value in CashCount!E1.
Observed behavior
The formula returns #VALUE!, potentially because the date format code does not match the Excel installation or the date is stored as text.
Before you start

Check the value in CashCount!C1 and note its intended day, month, and year. Also check which date format codes and formula argument separator your Excel installation accepts.

Solution 1Recommended

Use a date format code recognized by Excel

Use this approach when the date is valid but the TEXT format code causes an error.

1
Check the date format

Select CashCount!C1, open Format Cells, and look at the Date or Custom category for a date format recognized by your Excel installation.

2
Update the formula

In the formula cell, try ="Inventory activation date: "&TEXT(CashCount!C1,"dd.mm.yyyy")&", "&CashCount!E1. Replace the format code with the appropriate localized code if your Excel version requires one.

3
Check the result

Press Enter and confirm that the output contains the intended date and the value from CashCount!E1. If Excel uses semicolons as argument separators, replace the comma inside TEXT with a semicolon.

Use a date format code recognized by Excel
Concatenation is not the date fix: The ampersand joins values just as CONCATENATE does, but switching operators alone will not correct an invalid date or format code.
Work with dates in WPS Spreadsheets

Combine formatted dates and text in WPS Spreadsheets

Use WPS Spreadsheets to check a date value and combine it with a label and another cell using the TEXT function.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Check the date cell: Select CashCount!C1 and use Home > Number Format to check whether the value is a date. If it is text, convert it to a date recognized by the spreadsheet.
  3. 3. Enter the formula: Select the output cell and enter ="Inventory activation date: "&TEXT(CashCount!C1,"dd.mm.yyyy")&", "&CashCount!E1. Adjust the format code or argument separator if required by your settings.
  4. 4. Review and save: Press Enter, verify the displayed date, and use File > Save As to save the workbook in Excel format.
Format dates inside a combined text resultOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and cell formatting
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether an Excel date is stored as text?

Select the cell and choose General from Home > Number Format. A real Excel date normally displays as a serial number; text remains unchanged.

Why does a date format code work in one Excel installation but not another?

Some Excel versions use localized date format codes. Check the formats available under Format Cells > Date or Custom and use a code recognized by your installation.

Can I use CONCATENATE instead of the ampersand?

Yes. CONCATENATE and the ampersand can both join the label, formatted date, and cell value. The date still needs to be valid, and TEXT must use an accepted format code.

What if Excel rejects the formula when I enter it?

Check the argument separator used by your Excel installation. Some regional settings require a semicolon instead of a comma between the arguments in TEXT.