This week, learn the simple solution to last week's challenge: Can you avoid re-entering integer values that are supposed to be percentages.
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.