Excel 97 Function Problem

Ok- it is 97 not 2000 (were a little behind) but the downloaded CC reports from Verisign which import well don’t/won’t calculate. I have tried format cells into everything I can think of/tried programing cells…sum is still 0, any ideas?
thanks in advance
L