752
Chapter 26 Using Formulas and Functions
Converting Values to Text Before Concatenating
When I try to combine a cell that contains text with one that contains a date, the result is nonsense.
The cell that holds the date is correctly formatted, but the resulting text says something like “Today is
38059” instead of displaying a date.
As you’ve seen, Excel ignores the formatting of the original cell when concatenating the two
values and instead displays the serial date value. Before concatenating a date with text, you
must convert the date to text and choose a format. Use the
TEXT function followed by a for-
mat in quotation marks. If the date is in ...