Thread: How to concatenate text & date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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.
Reply With QuoteReply With Quote