Simple question...
In my cell D11, someone has formatted the cell to reflect a currency setting. I want to overide that setting to reflect a whole number. The above code wont change my D11 cell to reference a whole number.
Instead, when I go back to D11 it shows the currency format. How do I override it with VBA code? I know I can directly override the D11 by using the format function within excel, but I want to override with VBA code in case I have other cells like this.
Thanks in advance,