not to reduce Fractions

rxp214

New Member
Joined
May 4, 2006
Messages
5
Hello, I'm a teacher that has been delegated a task by a supervisor, and I need some help. My boss wants scores reported as fractions for end year tests. The denominator tells us which individual test, but excel wants to keep reducing the fraction. How can I get excel to not reduce the fraction. :(
 
click on cell D1. then hit CNTRL + C (This copies the cell). then highlight all of the cells that you want to copy that formula to, and then hit CNTRL + V (This pastes.) you can also use the right click on any cells that you have highlighted to modify the cells in any way you like. I would encourage you to spend alot of time messing around in Excel and figuring out what the features do by using HELP. Eventually, you'll get to know the program well enough.
 
Upvote 0

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,215,455
Messages
6,124,937
Members
449,196
Latest member
Maxkapoor

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top