I've created a excel template to export task from schedule. I need calculate a days in this excel template to something else. And now I have problem, because after export dates (start date and finish date) are not a date but text in excel.
In template cells with dates have datum formating.
When I export by CSV and after import to excel dates are dates, but export by CSV I export everything, not what I want.
I dont know why this is happening nor how to resolve.
But, if no-one else can suggest a fix then a workaround could be to have a custom button (vb) in your excel template which converts the column with dates in to date format.
I've been thinking about custom button but if I can do this without VBA it should be better.
Another way, I can export to CSV and import to excel by VBA what I want to import...
But I still looking for a solution without VBA ;)