Sounds like they are 'Numbers Stored As Text'

Try copying a blank cell
Highlight the problematic cells (the ones you have to click into and press enter for it to work)
Right click - Paste Special - Values - Add - OK.