Wednesday, 25 June 2014

Export to Excel change cell format to percentage format in Microsoft Dynamics AX 2012

Below is the code snippet to change the cell format to percentage format.

cells.range("D21:D30").numberFormat("0.00%");

Below is the link for more info on excel cells format.

http://www.teachexcel.com/free-excel-macros/m-72,Format-Cells-as-a-Percentage-in-Excel-Number-Formatting.html


Thanks

Muhammad Zahid.

No comments:

Post a Comment