date and time / timestamp bug when exporting to excel

[StevenC880]

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

[StevenC880]

nevermind, this was answered in a previous post, thanks

[Patrick_W]

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