Can not change the numberformat
this function is in a module in test.xla
Function numberformat_pc_test()
ActiveCell.NumberFormat = "0.00"
numberformat_pc_test = 0.234
End Function
"X.Yu" wrote:
I try to change the cell number format in my "add in" module using following
statement:
ActiveCell.NumberFormat = "0.00%"
But it does not change the the format, the cell number format was still
"General".
Any suggestion?
|