OLE: export quantity with decimals according to UoM

Dear Guru,

I encounter a problem when exporting data from Itab to Excel using OLE.

In the itab, there are many Quantity fields (with UoM). When I export to Excel, I want the number of decimals of each quantity field must comply with UoM (for ex: PC with 0 decimal, Kgs with 3 decimals).

I try to write the qty to text, it's ok but I also need the exporting qty is formatted as a number in Excel so user can do a sum.

The solution for this problem seems complicated. I have to write qty to text, convert text to number...But for a large number of data, it is really slow.

Is there anybody encounter the same problem? Please advice the solution.

Thanks.