excel help?

G'day
Gotta bit of a problem, I'm downloading data (trades) but the auto sum won't work with it. If I delete the numbers then re-type them it works. Any ideas?
I've tried "format cells" to no avail
tia
cheers
Rod