I would guess that the cells got confused when the import happened - if
you run a macro that does the following


sub update
for each cell in range("A1:A2000")
'change the range to whatever you need
cell.value=cell.value
'looks slightly silly, but fixes the problem
next
end sub