Clear contents and formatting of an Excel cell with a single command
Use the .Clear method. Sheets(“Test”).Range(“A1:C3”).Clear MSDN documentation here.
excel-2013
Number format in excel: Showing % value without multiplying with 100
You just have to change to a Custom format – right click and select format and at the bottom of the list is custom. 0.00##\%;[Red](0.00##\%) The first part of custom format is your defined format you posted. Everything after the semicolon is for negative numbers. [RED] tells Excel to make the negative numbers red and … Read more
be careful parts of your document may include personal information that cannot be removed by the Document Inspector
Also ran into that. It seem, after running the Document Inspector in Excel, it will show you this warning whenever you save your file. Go to File > Info and click in “Allow this information to be saved in your file”. The next time you save there should be no more warning.