Excel Datetime format issue in excel

[TusharGonjari]

Dear all,

I am trying to export an Excel-file form Qlik Sense. Everything seem to work well, except for the date format.
Date is along with time but it shows colon and dot (:.) at the end of date in excel cell.
But in preview it shows correct date.
I don't want colon and dot (:.) in this sheet.

Thank you.

[Patricia_Silva]

Hello @TusharGonjari, which version of Qlik Sense are you using? Is it Qlik Sense Enterprise on Windows or Qlik Sense Enterprise on SaaS? Could you please also attach a sample app so I can test it? Thank you!

[TusharGonjari]

Hi @Patricia_Silva 

Thanks for your reply.

I am using Qlik sense enterprise on Windows.

I can not attach sample since I am working on project which has highly secured data.

Sheet contains table and we are extracting table information into excel.

Hope this will help.

Thanks ! Appreciate your help on this.

[Patricia_Silva]

Hello @TusharGonjari, would it be possible for you to provide a small sample app, I mean not with all the information your customer has, I mean just for me to replicate the issue. Also, which version of Qlik Sense are you using?