Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
In recognition of Martin Luther King Day, our Support Centers will be open with limited hours on Monday (1/20) from 10AM ET to 6PM ET. Visit our Help Center to see all of the ways you can find answers to your questions.
I am trying to generate graphs of open rate and click throughs based on the timestamp when I export to excel. When I open in excel, the time imports as 10:59pm instead of 10:59 PM: the missing space after the last number makes the date/time read as text instead of a time, and there is no way to reformat with writing a short script to add the space to every line item. Can Constant Contact reformat how time is displayed on your end, or at least reformat when someone clicks export? I called in today, case# 22339859
... View more
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?
... View more