Excel 2007 add function of two cells return zero

Even after formatting cells as numbers their sum adds up to zero. How to correct this anomaly?