Hi Mark,
Follow these steps:
1. In an empty cell, type "100" (without the quotes) and hit enter.
2. Select/highlight the cell with 100, and use Ctrl+C to copy it.
3. Select/highlight the cells you want to change to percent, then use "Paste Special > Divide".
4. Select the "Percent" format, or use Ctrl+Shift+% for the cells (selected in step three).
5. You should no longer require the 100 (from step one), so it may be deleted.
Steps one to three gets rid of the extra 00s, then step four sets the format to display the percent % sign.
Bookmarks