concatenating two fields in one cell, of which one is a date.

's Computer Specifications

I have two cells:
Cell A2 Today's date is
Cell A3 02/08/2007
I want cell A4 to state: Today's date is 02/08/2007

When I use the formula =CONCATENATE(A2," ",A3) I get the following:
Today's date is 17669

How do I make this state [Today's date is 02/08/2007] in one field?

's Computer Specifications

One way:

=A2&" "&TEXT(A3,"dd/mm/yyy")

Or

=CONCATENATE(A2," ",TEXT(A3,"dd/mm/yyy"))

Regards

Trevor

"Manuel Murieta" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have two cells:
> Cell A2 Today's date is
> Cell A3 02/08/2007
> I want cell A4 to state: Today's date is 02/08/2007
>
> When I use the formula =CONCATENATE(A2," ",A3) I get the following:
> Today's date is 17669
>
> How do I make this state [Today's date is 02/08/2007] in one field?
>

's Computer Specifications

=CONCATENATE(A2," ",TEXT(A3, "mm/dd/yyyy"))

"Manuel Murieta" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have two cells:
> Cell A2 Today's date is
> Cell A3 02/08/2007
> I want cell A4 to state: Today's date is 02/08/2007
>
> When I use the formula =CONCATENATE(A2," ",A3) I get the following:
> Today's date is 17669
>
> How do I make this state [Today's date is 02/08/2007] in one field?
>

's Computer Specifications

On Thu, 8 Feb 2007 16:55:22 -0500, "Manuel Murieta" <(E-Mail Removed)>
wrote:

>I have two cells:
>Cell A2 Today's date is
>Cell A3 02/08/2007
>I want cell A4 to state: Today's date is 02/08/2007
>
>When I use the formula =CONCATENATE(A2," ",A3) I get the following:
>Today's date is 17669
>
>How do I make this state [Today's date is 02/08/2007] in one field?
>

=CONCATENATE(A2," ",TEXT(A3,"mm/dd/yyyy"))

--ron

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenating Date and Time from two differnt fields	Tamer Ibrahim	Microsoft ASP .NET	1	17th Jan 2008 12:54 PM
Concatenating Date and Time Fields for Lag Time Analyses	=?Utf-8?B?UmljaFQ=?=	Microsoft Access Queries	2	3rd Aug 2004 07:05 PM
Concatenating fields	Dorlene	Microsoft Excel Misc	3	13th May 2004 04:33 PM
concatenating fields	David Popham	Microsoft Access Reports	1	23rd Sep 2003 06:44 PM
Re: Concatenating date fields into text	David Morrison	Microsoft Excel Worksheet Functions	0	25th Jun 2003 05:05 PM