ExcelBanter - changing cell format from number to percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - changing cell format from number to percentage (https://www.excelbanter.com/excel-programming/312220-changing-cell-format-number-percentage.html)

harris

changing cell format from number to percentage

how to change cell format from number to percentage..with 2 decimal places,
using vba.

Bill[_28_]

changing cell format from number to percentage

Try

ActiveCell.NumberFormat = "0.00%"

"harris" wrote in message
...
how to change cell format from number to percentage..with 2 decimal
places,
using vba.

All times are GMT +1. The time now is 10:03 PM.