You can use a formula or a macro, not just formating:

=DATE(2000+RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))

and then format the formula cel as:
d/m/yyyy

The macro would do the same thing in VBA, but only use one cell, not two.
--
Gary''s Student - gsnu200745


"Dermot" wrote:

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