Forum Discussion
Short date display in Excel in concatenated filed
I have a cell which contains a serial date which I have formatted as a short date display. In another field I have text that I want to merge with the cell which contains the short date. The text fi...
Add TEXT(<date>,"dd/mm/yyyy") instead of <date>
Thanks that worked
="Monthly Export data collected through - "&TEXT(+J1,"MM/DD/YYYY")
Gerry, exactly. Couple of comments
1) You don't need +J1, use TEXT(J1,...
2) As variant you may format your J1 cell (Ctrl+1, Number, Custom) as
"Monthly Export data collected through - "dd/mm/yyyy
You'll have the same text shown in J1, but the cell value will be the date with which you may perform other calculations.