I fixed this exact issue by rebooting Excel. Same symptoms as you. I saw the values in the field, but it appeared in the cell as 0. I could get them to appear by clicking on each cell and hitting enter. Fix is that I closed all windows of Excel and rebooted the application and then tried opening the .xls again. Worked!