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.

What happens with product feedback?

Find out about the life-cycle of a product idea when it is posted on our Feedback board.

Read More

What's New

See the latest Constant Contact product release notes and updates.

Learn More