excel formula not calculate as expected

[jliang84]

I am facing difficulties where my excel not calculate the formula for certain column.
Refer to the attached jpg file for more detail.
Anyone could help me?

or link Dropbox - excelask.jpg

 

[jliang84]

i dont know how to upload jpg files here ..so only could upload at dropbox.. kindly assist ya....

 

[audax48]

May be SELECT the columns and format as GENERAL...i had similar problem and solved it doing that

 

[jliang84]

Hi Audax48, Thanks for your reply. But no luck, i tried set to general, still the same.....