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

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

Excel stores dates as numbers. Excel's date range is Jan. 1, 1900, day 1
through Dec. 31, 9999, day 2,958,465. March 16, 2008 is day 39,523. What you
see if you format that as some type of date, say mm/dd/yy, you will see
03/16/08 Formatting in Excel is for human consumption. Your dates may be
text and not Excel dates. If you press Ctrl+Accent grave, the key above the
tab key, you will see numbers in the cells containing Excel dates. Press
Ctrl+Accent grave to return to normal display

Tyro

"Dickery1" wrote in message
...
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