P3e to Excel date format

Member for

18 years 9 months

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 months

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 months

Minhas,

very easy:

Edit --> User Preferences --> Dates. The format you choose here will be used for the Export file-

Regards

Dieter