One owrkaround is, in excel, drag-selecting the cells and hitting "text to column" icon. That may be nice but how to tell simulation to output it that way without having to do "text to columns"... I don't know.
One pet peev here is having to make excel documents that are not associated with the model. I hate having a thousand models and excel spreadsheets with no parent/child relationship to eachother besides me vaulting both the spreadsheet and the model together. I suck at that. Somebody chime in and say its all better now and here's why please.
I am also facing the same issue but there is no option in SW2012 to align it to spreadsheet, even if you download to .csv or .txt
One has to pick each value seperatley and paste it into report.