I have used the CONCATENATE function to link together a few cells. The first is a number, the second text and the last 3 are dates.

I am having a problem with the dates.

If in the original cell the date is written for example as 12/02/12 then the formulated cell is showing as a date.
If the original cell is written as 12/02/2012 the formulated cell is returning a number instead of a date

The formula = =CONCATENATE(B6,", ",M6,", ",P6,", ",O6,", ",S6)
The returned value = 51330, Pro MK 3, 20/10/11, 15/02/12, 41136

I have tried changing the original cell format to dd/mm/yy but this makes no difference.

Can you give me some other options to try.

Thank you