I am attempting to make a graph of Open-Rate-by-Time in excel. I export the data from the Open Rate tab, and when I open in Excel the timestamp is read as 1/23/2018 7:08pm. Excel reads this as text, not a date, and there is no way to auto format a large dataset. If you simply add a space before the pm, so the date reads 1/23/2018 7:08 pm, all of a sudden excel recognizes that as a time/date, and you regain all functionality.
Is there an easy way to add that space to my dataset? Or better, will Constant Contact just reformat so every export shows properly?
Welcome back to the Community! Thank you for reaching out to us. This is a great question. So in order to get the Excel spread sheet to recognize it as a time/date, you would need to do a 'Find and Replace'.
Having that extra space added should fix it for you! I will also be submitting this as a feature request so that this step won't be necessary.
Please let us know if you have any further questions.
Desi_B Community & Social Media Support
If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.
Increase your profitability by integrating your email marketing and social media. Download this guide and learn how you can achieve great results with email marketing and social media combined!
You can post a new message in the Community or find us on Twitter Mon-Fri 8am-8pm ET, Sat 10am-8pm ET, & Sun 10am-6pm ET. We've got real people waiting to help you out. Click below to start a conversation!