Thread: date Concatenation
View Single Post
  #4  
Old April 11th, 2010, 02:29 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
  
Posts: 15,759
Default date Concatenation
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066

For the date in m/d/yyyy format...

=T6&" "&TEXT(U6,"m/d/yyyy")

--
Biff
Microsoft Excel MVP


"gb_S49" wrote in message
...
Hi,
I am trying to date Concatenate 2 cells. One contains text the other date.
How can I get the date to display as a date?
=T6&" "&U6 returns ESTIMATE 40066