Q. What is the difference between a regular paste in Microsoft Excel and Paste Special? A. As an accountant, you know how to copy or cut and paste in Microsoft Excel. On PCs, it’s as simple as Ctrl+C ...

So you have to divide it by 100. That's where Paste Special comes in. First, type 100 in a cell and copy it. Then, select all the numbers you want reformatted, select Paste Special, click the Divide ...