topic Re: Excel export issue in QlikView https://community.qlik.com/t5/QlikView/Excel-export-issue/m-p/497961#M186116 <HTML><HEAD></HEAD><BODY><P>Change the formatting of the cells from text to number before entering the formulas.</P></BODY></HTML> Thu, 15 Aug 2013 16:29:07 GMT Gysbert_Wassenaar 2013-08-15T16:29:07Z Excel export issue https://community.qlik.com/t5/QlikView/Excel-export-issue/m-p/497960#M186115 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I have a date filed in a Qlikview Table ... when i export this table to excel and type a formula to extract month and year . The formula fails... see below image </P><P><IMG __jive_id="45578" class="jive-image-thumbnail jive-image" onclick="" alt="Capture1.JPG" src="https://community.qlik.com/legacyfs/online/45578_Capture1.JPG" width="450" /></P><P></P><P>I can get month and year of "receiptDate" in qlikview but my users want to do this in excel depending on their need.</P><P></P><P>This is only happening to files exported from qlikview... but if i open new excel sheet and type same formula it works fine </P><P></P><P>I have attached the file here. Appreacite help on this&nbsp; </P></BODY></HTML> Thu, 15 Aug 2013 16:19:31 GMT https://community.qlik.com/t5/QlikView/Excel-export-issue/m-p/497960#M186115 2013-08-15T16:19:31Z Re: Excel export issue https://community.qlik.com/t5/QlikView/Excel-export-issue/m-p/497961#M186116 <HTML><HEAD></HEAD><BODY><P>Change the formatting of the cells from text to number before entering the formulas.</P></BODY></HTML> Thu, 15 Aug 2013 16:29:07 GMT https://community.qlik.com/t5/QlikView/Excel-export-issue/m-p/497961#M186116 Gysbert_Wassenaar 2013-08-15T16:29:07Z