Support Board

Date/Time: Mon, 29 Apr 2024 03:09:39 +0000

Post From: Trade Activity Log - Date Time format after export to Excel

[2017-01-19 11:08:06] Link To Thread - Link To Post [Go To First Post]
Marmany - Posts: 303
This is an observation rather than a complaint. When Trades tab is exported to Excel using Edit/Copy All/Paste the format in Entry & Exit Date Time columns changes from YYY-MM-DD HH:MM:SS.xyz to MM:SS.0 When the Excel columns are manually re-formatted to the full format all the data is visible. Prior to a SC update I applied last December the full format was retained in Excel as the data was imported. When Trades tab is saved as a txt file and opened as a Sierra spreadsheet the full format is retained. However on copying that file and pasting into Excel the columns are formatted MM:SS.0 For info Copy All/Paste into either MS Notepad or Word and the full format is retained. Nothing has been changed on my Excel settings since the formatting was retained last November. Obviously it is not a big deal for me to re-format a couple of Excel columns. Please advise if this makes sense to you and there is a simple way to revert so that data imports directly to Excel in the full format. Many thanks