One column is filled with dates but in each cell one can see the dates in
number format (though the formatting has been selected as date type) and at
the same time each cell will give the date near the space provided adjacent
to the formula bar but in the cell it will display the number.

Please suggest what could be the problem??