When the date field is concatenated with any text field in excel, in the result field the date formate may change. The date value may also be converted to some other format. To avoid this convert the date field to the text field while concatenating. Ex: COCATENATE(TEXT(C2,”dd/mm/yyyy”),E2) In this formula, the date value in C2… Continue reading Concatenate the Date field in Excel