If you can't format the dates as you're indicating below, than they
are probably stored as text and not as an excel date.

If all your dates are setup as they are below (i.e. 2 digit month,
some delimiter, 2 digit day, some delimeter, 4 digit year) then use
this formula assuming the dates start in cell A1.

=IF(ISTEXT(A1),DATE((RIGHT(A1,4)),(LEFT(A1,2)),(MI D(A1,4,2))),A1)



On Mar 16, 3:03 am, Dickery1 wrote:
Hello
I use the canadian office 2003. My dates are messed up. even though i
tried to format it in date format, it uses different seperators to as
delimitors. how do i fix it.
10/05/2007
06/07/2007
02/09/2007
07/12/2007
01-14-2000
01-15-1991
01-15-2003
01-15-2008
01-22-1998
01-25-2005
01-26-1998
01-27-2005
01-27-2006
01-29-1993
01-31-1994