Posted to microsoft.public.excel.misc

mike_vr

external usenet poster

Posts: 42

Simple concatenation including date

Hi there

Trying a very simple concatenation =A18 & " " & B18 but the problem is, B18
is a date. So whenever it calculates it comes back as "National Enquirer
40057" instead of "National Enquirer 01-Sep" as the two cells currently hold.

Is there something I'm missing from my formula?

Thanks
Mike

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date/Time concatenation	Al	Excel Worksheet Functions	4	March 17th 09 02:16 PM
How to add 30 days to date in another column, including Sat/Sun?	Sherri	Excel Worksheet Functions	2	January 26th 08 04:20 AM
Date in Concatenation	FARAZ QURESHI	Excel Discussion (Misc queries)	2	September 20th 07 04:55 PM
Including today's date	Rich D	Excel Discussion (Misc queries)	3	December 8th 06 08:19 PM
date and text concatenation	littleps	New Users to Excel	8	July 28th 05 11:23 AM

All times are GMT +1. The time now is 03:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us