Cell linking displayed in text

I am trying to have a cell in a diffrent work sheet display information from another sheet.

I entered ='Weapons Table'!A48 and it is displaying in text not what is actually in that cell.
on the cell above it I have entered ='Weapons Table'!A47 and it displays fine.

I've tried typing = then just clicking the cell, and it is still just displaying it as text. I've spent 3 days on this sheet and have only 1 error, that is driving me crazy.

I'm on excel 2007 and have exhausted all my collegues who have any excel expertise. please help.