Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link