I am looking to use a vlookup formula to display a string of text and a date, I can get the string of text part working but the date just display as a number rather than as 09 July 2013, Please see formula below for details.

=IF(VLOOKUP($F$4,client_list2,30,FALSE)="","",VLOOKUP($F$4,client_list2,29,FALSE)&" "&VLOOKUP($F$4,client_list2,30,FALSE)&" "&$X$4&" "&AC4)

AC4, the final part of the formula is where the date is stored.

Thanks in advance

JD