I have checked many links to date formatting but can't find a solution.
I must be missing the point somewhere as I don't believe my question below
can be undocumented.

How do I format dates so I just enter numbers without any formating?
For example:
If I Enter 251005 in the cell I would like it to auto format to 25/10/2005.

Thanks in advance