Last week, we discussed a interesting problem that arises when you try to format existing integer values as percentages. For instance, the sheet below shows integers before and after. The resulting percentage values probably aren’t what you want. Allan.pettie and Joan.edington both gave similar answers. Joan’s is the most succinct.
The quickest solution is to use Excel’s Paste Special feature to divide the integers by 100, as follows:
- Enter the value 100 in a nearby cell.
- Select that cell and press [Ctrl]+C to copy it to the Clipboard.
- Select the cells that contain the integers you want to format as percentages. In this case, that’s A1:A14.
- From the Paste dropdown in the Clipboard group (on the Home tab), choose Paste Special. In Word 2003, choose Paste Special from the Edit menu.
- Click Divide in the Operation section of the resulting dialog box.
- Click OK.
With the cells still selected, click the Percent Style option in the Number group on the Home tab to format the percentages. In Word 2003, click Percent Style on the Formatting toolbar. This time, the formatted results reflect percent values that make sense.
Allan’s suggestion of formatting copied values has merit, if you need to retain the original values. For more Paste Special tricks, read 10 powerful ways to use Excel’s paste features.