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
Member for
18 years 7 months
Member for18 years7 months
Submitted by Minhas Shaikh on Wed, 2007-07-25 16:19
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
Member for
18 years 9 months
Member for18 years9 months
Submitted by Dieter Wambach on Wed, 2007-07-25 15:55
Member for
18 years 9 monthsRE: P3e to Excel date format
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
Member for
18 years 7 monthsRE: P3e to Excel date format
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
Member for
18 years 9 monthsRE: P3e to Excel date format
Minhas,
very easy:
Edit --> User Preferences --> Dates. The format you choose here will be used for the Export file-
Regards
Dieter