Date formatting in a concatenated list.

May 11, 2011 at 12:29:38
Specs: Macintosh
I have a situation where column A has dates formatted as MMM-YY, column B has numeric values, column C, another set of numeric values. In Column D, I'm trying to concatenate all three column in a comma-delimited list by doing the following: =A1&","&B1&","&C1. The original values in columns A1:C1 are: Sep-12, 332, 91.5. The result ,however, 39692,332,91.5. Is there a way to enforce the date formatting in this concatenated list?

See More: Date formatting in a concatenated list.

Report •


#1
May 11, 2011 at 12:33:11
Try

=TEXT(A1,"mmm-dd") & "," & B1 & "," & C1

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 11, 2011 at 12:45:44
That worked perfectly. Thanks. However, I changed "dd" to "yy" to get the year. Appreciate it!

Report •

Related Solutions


Ask Question