topic Text format on excel export in QlikView https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159649#M34210 <HTML><HEAD></HEAD><BODY><P>Guess i'm going to have to go the macro approach?</P></BODY></HTML> Mon, 14 Mar 2011 15:35:34 GMT 2011-03-14T15:35:34Z Text format on excel export https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159648#M34209 <HTML><HEAD></HEAD><BODY><P>I have and ID field that is formatted to look like a hyperlink (blue, underlined). I there an easy was to make this turn back to regular black text when exporting to excel? Right now it looks like a hyperlink in excel.</P><P>Thanks!</P></BODY></HTML> Mon, 14 Mar 2011 14:39:06 GMT https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159648#M34209 2011-03-14T14:39:06Z Text format on excel export https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159649#M34210 <HTML><HEAD></HEAD><BODY><P>Guess i'm going to have to go the macro approach?</P></BODY></HTML> Mon, 14 Mar 2011 15:35:34 GMT https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159649#M34210 2011-03-14T15:35:34Z Text format on excel export https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159650#M34211 <HTML><HEAD></HEAD><BODY><P>anyone.... going once...</P></BODY></HTML> Mon, 14 Mar 2011 19:28:00 GMT https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159650#M34211 2011-03-14T19:28:00Z Re: Text format on excel export https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159651#M34212 <HTML><HEAD></HEAD><BODY><P>You could create another object without the formatting but I think you would still need a macro. </P><P>I created one for this case. I export the object data to excel (it goes with the formatting). </P><P>After this, I send commands to excel to format it as I want. </P><P></P><P>Please, check sample app attached. </P><P></P><P>Best Regards, </P><P></P><P>Erich</P></BODY></HTML> Sun, 08 May 2011 17:13:33 GMT https://community.qlik.com/t5/QlikView/Text-format-on-excel-export/m-p/159651#M34212 erichshiino 2011-05-08T17:13:33Z