P3e to Excel date format
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Sorry Minhas
it was my mistake.
If you just want to create reports in Excel and not import the data again: Same with the user preferences. Then:
1. Create a report and choose, create ASCII. P3e will create a CSV-File and you can mark to open EXCEL immediately. Separator: in General ";" works the best, with some configurations ",".
2. You create a layout with all the informations you need in the table-area --> ctrl+A to select all data --> ctrl+C --> Open EXCEL --> New file --> ctrl+V
If you’ll want to import again - I remember I stumbled over this item some time ago - it seems that you’ll have to work with copy and paste and to modify the specific figures.
Hope this will help!
Dieter
Thanks Dieter.
I already have setpup in user preference but I am getting same result. Mean dates with time and hiphen. Also I am not getting same format which I have assigned in user preference.
There may be another way....or somthing else....
Minhas
Minhas,
very easy:
Edit --> User Preferences --> Dates. The format you choose here will be used for the Export file-
Regards
Dieter