Total mark / score out of a total

[Besh]

Within in one cell, how do I present a mark / score like so...

70 / 100 or 70 out of 100... somethign liek that.

I don't want to present this as a fraction. I.e. if the mark was 70/100 I want it displayed as such, I don't want it to self adjust to 7/10. Here's some further reference if needed. These are the formulas included in the mark:

E54 out of SUM(E54:F54)

Thanks, Besh

 

[MrKowz]

Try:
=E54 & " / " & SUM(E54:F54)

or
=E54 & " out of " & SUM(E54:F54)

 

[mikerickson]

If you format the cell with the custom format 0"/100" then 70 will appear as 70/100

If you format the cell with the custom format # ??/100 then .7 will appear as 70/100

 

[Besh]

Great, thanks to both of you.

 

[MrKowz]

Great, thanks to both of you.

Glad to help. Thank you for the feedback.