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?