Cancel
Showing results for 
Search instead for 
Did you mean: 

Excel template - dates

Creator
Creator

Hi everyone,

 

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.

1.JPG2.JPG

When I export by CSV and after import to excel dates are dates, but export by CSV I export everything, not what I want.

 

Regards,

2 REPLIES 2

Re: Excel template - dates

Phenom
Phenom

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.

Rich

Richard Bennett
Prospect PLM

Re: Excel template - dates

Creator
Creator

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 ;)