cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Teamwork & BIMcloud
About Teamwork, BIMcloud, BIMcloud Basic, BIMcloud Software as a Service, network settings, etc.

Formatting TeamWork activities in excell CSV

leceta
Expert
Hi all, this is a excell related issue, but lets see if somenoe can help me with this...

Iam trying to make a report of teamwork activities in excel,

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...


Now, i'am having troubles with the DATE format, its in a cell, and it looks like this

Sun Jun 12 2016 17:44:06 GMT+0200 (Hora de verano romance)


i cant figure out how to make excel interpret correctly the date. I guess its a regional formatting issue or something related...

I tried to parse the string with DATE() function,
=DATE(MID(A1;12;4);MID(A1;5;3);MID(A1;9;2))

but excel wont recognize 3 letters representation of the month as a proper month format...

i'am working with english version of excel and instead, my operating system is in spanish with spanish regional settings.

any advice would be appreciated.
thanks!

P.S. Is it possible to change the DATE format of activities for CSV export?
0 REPLIES 0

Didn't find the answer?

Check other topics in this Forum

Back to Forum

Read the latest accepted solutions!

Accepted Solutions

Start a new conversation!