Try removing the space inside the cell. When there is additional spaces in the cells you are selecting, Excel will treat them as text instead of Numbers. Worked for me.