topic Send To Excel Query in QlikView https://community.qlik.com/t5/QlikView/Send-To-Excel-Query/m-p/152806#M30098 <HTML><HEAD></HEAD><BODY><P>You can always do this in excel:</P><P style="padding-left:30px;">Select the range of cells that hold the text dates.<BR />Goto the menu: Data -&gt;Text to Columns<BR />Click Finish</P><P>Otherwise, you may have to create a seaparate field and play with it, like storing num(date) and then formating it as date in excel after export.</P><P>Hope this helps.</P></BODY></HTML> Mon, 10 Aug 2009 21:20:00 GMT disqr_rm 2009-08-10T21:20:00Z Send To Excel Query https://community.qlik.com/t5/QlikView/Send-To-Excel-Query/m-p/152805#M30097 <HTML><HEAD></HEAD><BODY><P>Hi Team</P><P>Pls refer the attachment. I am doing Sent To Excel from a Table box and from a Pivot.</P><P>Problem is with OpenDate field. From Tablebox it contain correct value but doesn't display it in full. From pivot it display value in full but in text format(left side of the cell). If i double click on a cell and then move out of the cell, display willbe like of Tablebox.</P><P>I need when i do Send To Excel, it should display the values in date format and in full.</P><P>Any workaround.</P></BODY></HTML> Mon, 10 Aug 2009 13:37:31 GMT https://community.qlik.com/t5/QlikView/Send-To-Excel-Query/m-p/152805#M30097 2009-08-10T13:37:31Z Send To Excel Query https://community.qlik.com/t5/QlikView/Send-To-Excel-Query/m-p/152806#M30098 <HTML><HEAD></HEAD><BODY><P>You can always do this in excel:</P><P style="padding-left:30px;">Select the range of cells that hold the text dates.<BR />Goto the menu: Data -&gt;Text to Columns<BR />Click Finish</P><P>Otherwise, you may have to create a seaparate field and play with it, like storing num(date) and then formating it as date in excel after export.</P><P>Hope this helps.</P></BODY></HTML> Mon, 10 Aug 2009 21:20:00 GMT https://community.qlik.com/t5/QlikView/Send-To-Excel-Query/m-p/152806#M30098 disqr_rm 2009-08-10T21:20:00Z