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.
Try TEXT(D1,"mm/dd/yyyy")
in your concatenate.
=CONCATENATE(A1," ",B1," ",C1," ",TEXT(D1,"dd/mm/yyyy"))