Use this on the dates:

TEXT(A1,"mmm-yyyy")

--
Biff
Microsoft Excel MVP


"JPS" wrote in message
...
HELP! I am concatenating five columns of data into one column and dates
are
in two of the columns. The concatenated column displays the numeric date
value from the source column, and I need the date in the concatenated
column
to show as mmm-yyyy.
--
JPS