Login Page - Create Account

Support Board


Date/Time: Fri, 07 Feb 2025 18:16:25 +0000



Post From: Extracting transactional data as a CSV or Excel file

[2020-06-08 02:15:31]
User144295 - Posts: 70
1. exported from sierra to txt delimited. no problem.
2. opened by excel as tab delimited. no problem in small preview window all looks good. (now i realized i had to switch DateTime column to text as importing.
3. finish and opened in excel sheet. looks good now.

observation (if i import DateTime as general or date/time column it is importing in 90% as this 3.6.2020 16:11 and 10% as this 2020-06-03 16:17:09.069)
as text, it looks 100% as this 2020-06-03 16:17:09.069

we can close the issue now. i just wanted to reply with observation.
thanks, bye