Dear all,
Is there a bug that crystal report thousand separator cannot functional when export numbers to excel?
i want to show space instead of comma so that 1,xxx will be 1 xxx.
I also found a [solution |http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_bi/sap%28bd1lbizjptawmq==%29/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333333333334333633303336%7D.do](change numbers to text) but my supervisor does not allow for it. So how can I do to solve this problem?
Furthermore, is there any ways in Crystal Report to set the excel Format cells(so that the problem above can be solved)?
Thanks so much.
btw I'm using crystal report 9... a bit older version.