date and time / timestamp bug when exporting to excel

0 Votes
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
Regular Participant

nevermind, this was answered in a previous post, thanks

Status changed to: Closed - No Action

Glad you were able to find the answer!  Let us know if there's anything else you need assistance with.

Introducing our new Feedback area

Our Feedback board is changing! From updated statuses to clearer processes, we're working to improve the conversation between you and our Product teams

Visit the Blog
What's New?

See the latest Constant Contact product release notes and updates.

Learn More