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.
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