excel 1997-2003
Try setting recalculation to manual "TOOLS/OPTIONS/CALCULATION/MANUAL"

excel 2007-2010
Try setting recalculation to manual "FILE/OPTIONS/FORMULAS/WORKBOOK CALCULATION/MANUAL"

Remember to go back to change back AUTOMATIC if you going to change player vs player number.

or

you could use 'Edit - Paste Special - Value' to remove the formula.

It only way will work to stop change it every time you put in 1 cell.

If you happy? Please click solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED

If you really happy with it. Click a little star on the left bottom side.

Good luck and enjoy.