Hi,
thanks for your reply. None of the date formats that I am going to get
in the narratives will be excel date formats as they always appear in
the middle or end of a text string. The possible ways I can think of
right now are as below:
03 Sep 09
3 Sep 09
03Sep09
3Sep09
3/Sep/09
03/Sep/09

those are the formats I have noticed as entered by the users.