To display qty in integer when we export it to excel in Ax 2012

Hi All,

Request your suggestions/ Quick Solutions.

When I export the data into excel from any form in ax (Eg: on hand form in inquiries), I need to display the quantity field in integer format / hide the decimals.

Currently it shows up decimal, as qty is of real type.

Any real quick suggestion appreciated.

Thanks in advance,

Shon