topic Formatting problem while export to excel in QlikView https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654688#M239200 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am exporting multiple objects through macro to excel.</P><P></P><P>In excel format has been changed from 10,846,100,200 to 1.085E+10.</P><P></P><P>Is there a way so I can get the actual 10,846,100,200</P><P></P><P>I appreciate your help</P><P></P><P>Thanking all</P><P><BR /> </P></BODY></HTML> Fri, 17 Oct 2014 17:45:20 GMT Anonymous 2014-10-17T17:45:20Z Formatting problem while export to excel https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654688#M239200 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am exporting multiple objects through macro to excel.</P><P></P><P>In excel format has been changed from 10,846,100,200 to 1.085E+10.</P><P></P><P>Is there a way so I can get the actual 10,846,100,200</P><P></P><P>I appreciate your help</P><P></P><P>Thanking all</P><P><BR /> </P></BODY></HTML> Fri, 17 Oct 2014 17:45:20 GMT https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654688#M239200 Anonymous 2014-10-17T17:45:20Z Re: Formatting problem while export to excel https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654689#M239201 <HTML><HEAD></HEAD><BODY><P>Excel is changing the format of the number because the column isn't wide enough to display it.</P><P>You can widen the column in Excel.</P></BODY></HTML> Fri, 17 Oct 2014 18:23:47 GMT https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654689#M239201 m_woolf 2014-10-17T18:23:47Z Re: Formatting problem while export to excel https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654690#M239202 <HTML><HEAD></HEAD><BODY><P>Thanks Michael, I appreciate your help</P></BODY></HTML> Fri, 17 Oct 2014 18:31:29 GMT https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654690#M239202 Anonymous 2014-10-17T18:31:29Z Re: Formatting problem while export to excel https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654691#M239203 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It just worked fine with me.</P><P>what version of Office you tried with I tried with Office 2013 and it worked.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Fri, 17 Oct 2014 18:33:31 GMT https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654691#M239203 ashfaq_haseeb 2014-10-17T18:33:31Z Re: Formatting problem while export to excel https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654692#M239204 <HTML><HEAD></HEAD><BODY><P>Sorry Ashfaq</P><P></P><P>I am using MS 2010</P></BODY></HTML> Wed, 29 Oct 2014 16:34:53 GMT https://community.qlik.com/t5/QlikView/Formatting-problem-while-export-to-excel/m-p/654692#M239204 Anonymous 2014-10-29T16:34:53Z