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

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

T.
I knew this was a simple solution... As always I appreciate help from the
"experts"
--
JPS


"T. Valko" wrote:

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"JPS" wrote in message
...
T.
I knew this was a simple solution... As always I appreciate help from the
"experts"
--
JPS


"T. Valko" wrote:

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