https://community.graphisoft.com/t5/Teamwork-BIMcloud/Formatting-TeamWork-activities-in-excell-CSV/m-p/291509#M1560 <DIV class="actalk-migrated-content"><R>Hi all, this is a excell related issue, but lets see if somenoe can help me with this...<BR /> <BR /> Iam trying to make a report of teamwork activities in excel, <BR /> <BR /> In order to accomplish that, i export teamwork activities as CSV file and import it to excel as a text data, then parse it dividing information in columns. Thats ok...<BR /> <BR /> <BR /> Now, i'am having troubles with the DATE format, its in a cell, and it looks like this<BR /> <BR /> <B>Sun Jun 12 2016 17:44:06 GMT+0200 (Hora de verano romance)</B><BR /> <BR /> <BR /> i cant figure out how to make excel interpret correctly the date. I guess its a regional formatting issue or something related...<BR /> <BR /> I tried to parse the string with DATE() function,<BR /> <B>=DATE(MID(A1;12;4);MID(A1;5;3);MID(A1;9;2))</B><BR /> <BR /> but excel wont recognize 3 letters representation of the month as a proper month format...<BR /> <BR /> i'am working with english version of excel and instead, my operating system is in spanish with spanish regional settings.<BR /> <BR /> any advice would be appreciated.<BR /> thanks!<BR /> <BR /> P.S. Is it possible to change the DATE format of activities for CSV export?</R></DIV> Sun, 12 Jun 2016 18:33:22 GMT leceta 2016-06-12T18:33:22Z https://community.graphisoft.com/t5/Teamwork-BIMcloud/Formatting-TeamWork-activities-in-excell-CSV/m-p/291509#M1560 <DIV class="actalk-migrated-content"><R>Hi all, this is a excell related issue, but lets see if somenoe can help me with this...<BR /> <BR /> Iam trying to make a report of teamwork activities in excel, <BR /> <BR /> In order to accomplish that, i export teamwork activities as CSV file and import it to excel as a text data, then parse it dividing information in columns. Thats ok...<BR /> <BR /> <BR /> Now, i'am having troubles with the DATE format, its in a cell, and it looks like this<BR /> <BR /> <B>Sun Jun 12 2016 17:44:06 GMT+0200 (Hora de verano romance)</B><BR /> <BR /> <BR /> i cant figure out how to make excel interpret correctly the date. I guess its a regional formatting issue or something related...<BR /> <BR /> I tried to parse the string with DATE() function,<BR /> <B>=DATE(MID(A1;12;4);MID(A1;5;3);MID(A1;9;2))</B><BR /> <BR /> but excel wont recognize 3 letters representation of the month as a proper month format...<BR /> <BR /> i'am working with english version of excel and instead, my operating system is in spanish with spanish regional settings.<BR /> <BR /> any advice would be appreciated.<BR /> thanks!<BR /> <BR /> P.S. Is it possible to change the DATE format of activities for CSV export?</R></DIV> Sun, 12 Jun 2016 18:33:22 GMT https://community.graphisoft.com/t5/Teamwork-BIMcloud/Formatting-TeamWork-activities-in-excell-CSV/m-p/291509#M1560 leceta 2016-06-12T18:33:22Z