I have a workbook that provides for a cell to have a date entered as part of
the approval process. I then want to include that date cell in a
concatenation with two otther cells to form a file name and then possibly by
way of a macro to copy and paste special that data so that it forms a text
string that someone can paste into an e-mail heading.

Every way I have tried it, the date always reverts to its core number format.

Am I trying to achieve the impossible witthin Excel 2003

Thanks in anticipation