Again we are talking about Excel.
Some people want the date to be specifically written in a cell in this order:
Number, word, Number.
13 November 2010
Select any cell; for example, A2.
A1 is considered as the cell for column heading. In this case, the heading is 'Date'.
In A2, type date as 13 November 2010
Observe that the date has become 13-Nov-2010.
This means writing 13 November 2010 as it is, is not the proper way.
Delete the matter.
In the same cell, type single inverted comma ( ' )in the cell.
Type 13 November 2010.
Observe that the cell has remain unchanged as 13 November 2010.