Thread: How to concatenate text & date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default 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
Reply With QuoteReply With Quote