Date is in numerical format

[coldeskimo]

I have created the following:

="Data as at 5pm "&TODAY()

and it results with the following:

Data as at 5pm 43172

Have formatted the cell to date. Doesn't work.
Why is the date defaulting to its numerical value?

Thanks

 

[oldbrewer]

Data as at 5pm 13/03/2018
		="Data as at 5pm "&TEXT(TODAY(),"dd/mm/yyyy")

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>