Right click the cells where you hve the percentages go to Format Cells >
Number tab > select Number from the list. This will convert 100% into 1 and
80% into .8
Now type 100 in any blank cell> copy that cell> again select all the cells>
right click>paste special>multiply.
Does that help?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.