Microsoft Excel - How do I keep dd/mm/yyyy format while using CONCATENATE function? [duplicate]

Question

I'm trying to bring together string values using the CONCATENATE function in Excel. When I try include a date (source formatting is dd/mm/yyyy) it converts to Number type data and I've no idea how to get around this.

My source data is as follows:
Cell A1: Eggs
B1: Milk
C1: Bread
D1: 08/04/2020

My formula: =CONCATENATE(A1," ",B1," ",C1," ",D1)

I put spaces between each value so they're not bundled up tightly together.

I'd like for this to return Eggs Milk Bread 08/04/2020, but it's coming back as Eggs Milk Bread 43929.

Any idea why this is, and how I might resolve it?

EDIT: Question answered below. Thanks to everyone who helped.

Answer 1

Try TEXT(D1,"mm/dd/yyyy") in your concatenate.

=CONCATENATE(A1," ",B1," ",C1," ",TEXT(D1,"dd/mm/yyyy"))