Combine day text and date problems
 

Hi,

I have the day of the week in A1 and the date in A2 and I'm trying to
combine them in A3 so it's appear as "10/1/08 Wednesday" but when I apply
the formula it comes out as (please see below in results). How can I do it
so it'll come out the way i want?

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722

Combine day text and date problems
 

I'm trying to combine them...so it's appear as "10/1/08 Wednesday"

One way:

=TEXT(A2,"m/d/yyyy dddd")

--
Biff
Microsoft Excel MVP


"mike" wrote in message
...
Hi,

I have the day of the week in A1 and the date in A2 and I'm trying to
combine them in A3 so it's appear as "10/1/08 Wednesday" but when I apply
the formula it comes out as (please see below in results). How can I do
it
so it'll come out the way i want?

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722

Combine day text and date problems
 

=a1&text(a2,"m/d/yyyy")
or
=a1&char(10)&text(a2,"m/d/yyyy")
(with wrap text checked)



mike wrote:

Hi,

I have the day of the week in A1 and the date in A2 and I'm trying to
combine them in A3 so it's appear as "10/1/08 Wednesday" but when I apply
the formula it comes out as (please see below in results). How can I do it
so it'll come out the way i want?

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722

--

Dave Peterson

Ignore
 

Ignore this...

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722

Combine day text and date problems
 

=TEXT(A2,"m/d/yyyy dddd")
so it's appear as "10/1/08 Wednesday"

Well, looks like I wasn't paying attention!

Try it like this:

=TEXT(A2,"m/d/yy dddd")

Result = 10/1/08 Wednesday


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
I'm trying to combine them...so it's appear as "10/1/08 Wednesday"

One way:

=TEXT(A2,"m/d/yyyy dddd")

--
Biff
Microsoft Excel MVP


"mike" wrote in message
...
Hi,

I have the day of the week in A1 and the date in A2 and I'm trying to
combine them in A3 so it's appear as "10/1/08 Wednesday" but when I
apply
the formula it comes out as (please see below in results). How can I do
it
so it'll come out the way i want?

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722

Ignore
 

Ignore this...

OK


--
Biff
Microsoft Excel MVP

Ignore
 

Go the long way around..

=month(A2)&"/"&day(A2)&"/"&year(A2)&" "&A1

"mike" wrote:

Ignore this...

A1: Wednesday
A2: 10/1/2008

Results: Wednesday 39722