I was working on an application which reads data from supplied spreadsheets. In one column it expected a %. It expected it to be written as 30 (for example for 30%). However some spreadsheets arrived with the % written as 0.30.

So to change these value within the spreadsheet (for any selected range) I wanted to simply multiple the selected cells by 100.

To achieve this is very simple. Just follow these steps

1. In an empty cell type 100
2. Now select the altered cell and copy it
3. Next, select the range of cells you wish to multiply by the copied value
4. Right mouse click on the cells and select Paste Special
5. Select the Operation Multiple and press OK
6. Finally delete the cell we added in step 1