How to convert number to date format after vlookup

[danhendo888]

I am using two vlookups in one cell such that the two values are joined together by a space

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=VLOOKUP(….)&" "&(VLOOKUP(…)

where the value returned appears as something like:

CompanyName 43658

The 43658 is the value returned from a column of dates.
Is it possible to change the 43658 to a ddmmyy format?
[/FONT]

 

[FormR]

Hi, try like this

=VLOOKUP(….)&" "&TEXT(VLOOKUP(…),"DD/MM/YYYY")

 

[danhendo888]

Thank you! It works perfectly