Thread: date Concatenation
View Single Post
  #1  
Old April 11th, 2010, 02:08 PM posted to microsoft.public.excel.worksheet.functions
gb_S49
external usenet poster
  
Posts: 28
Default date Concatenation
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