How to concatenate text & date
 

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

--
AcctCA755

How to concatenate text & date
 

One way:

=A1 & TEXT(B1," dd/mm/yy")

In article ,
AcctCA755 wrote:

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

How to concatenate text & date
 

If the date is in B1 then try
=A1 & (TEXT(B1,"mm/dd/yyyy"))

"AcctCA755" wrote:

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

--
AcctCA755

How to concatenate text & date
 

In A1 we have "payday "
In B1 put =TODAY()

In C1 enter:

=A1 & TEXT(B1,"mm/dd/yy")
--
Gary''s Student - gsnu200827


"AcctCA755" wrote:

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

--
AcctCA755

How to concatenate text & date
 

Try instead:

=A1&" "&TEXT(B1,"m/dd/yyyy")

HTH,
Jim



"AcctCA755" wrote:

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

--
AcctCA755

How to concatenate text & date
 

Thanks everyone it worked.
--
AcctCA755


"JMay" wrote:

Try instead:

=A1&" "&TEXT(B1,"m/dd/yyyy")

HTH,
Jim



"AcctCA755" wrote:

How do I combine paydate & 01/02/09?

=concatenate(A1,B1) formats the date as 35983.

I want the date to appear as 01/02/09.

--
AcctCA755