Put 100 in a cell copy it, select the range you want to divide and do
edit>paste special and select divide
delete cell with 100, only one extra cell used To get 8.00 out of 800 you
need to use number format like
0.00 or else it displays as 8
Enter 100 into any blank cell
Copy that cell
Select your range of data to convert
Select "Paste Special"
Choose the option for "Divide"
Click OK
Delete the 100 that you entered earlier
You may also need to adjust the formatting of your cells to show 2 decimal
places.
HTH,
Elkar
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.