ALV 下载到EXCEL里出现的问题

1.我用function 'CONVERSION_EXIT_CUNIT_OUTPUT' 来转化单位ST转成PC，然后再下载到EXCEL里，结果单位全显示为(*)。

解决方法：将单位的DATA TYPE 改为 CHAR3，就可以了。

（I have tried using the function 'CONVERSION_EXIT_CUNIT_OUTPUT' which converts the KAR to CAR in the ALV, but when I print it or check the print preivew ,  it shows asterisks (*) in the UoM field

I had the problem you have mentioned but when I used the function 'CONVERSION_EXIT_CUNIT_OUTPUT'  the problem was solved . The only thing that I can suggest you is , to give it a try, change the data type of UoM to char(3)）

2.下载到EXCEL里的数字，自动去掉前面的0。

例如05233333，下载到EXCEL里就成了5233333

解决：手工修改成文本格式（加英文单引号，再加0）

  或者打开一个空的TXT，然后把EXCEL拖进去