csv export option to format date

[web_design1]

when i export csv of campaigns, date comes with date and time, and i am unable to change the format in excel (i.e. remove time, want only date)

[Caitlin_M]

Hi @web_design1. I apologize for the delay in our reply but thank you for bringing this to our attention. I'm seeing the same thing happen when I download a CSV file of campaigns. There is a workaround by using the text to column feature in Excel that can make the column editable. I'll include a third-party link that includes more information about how to achieve this but please note that our support teams would not be able to assist with the creation of this file and it would need to be done on your own time. I'll open this request up for voting. 

[Frankie_P]

Hi everyone,

The good news is you can update this formatting in excel by highlighting column > Number > Short Date. Because this is also more of an Excel related issue, we recommend contact support directly. We are also going to close this idea. This doesn't mean that we aren't listening to your feedback! Please feel free to comment or vote on any of the other open ideas to let us know what you would like to see.