hi
custom fomat maybe
right click cell with date. click format cells.click number tab.
in the catagory window, click custom. in the type box enter....
yyyy/dd/mm
click ok.
you can now format any cell with this format.

regards
FSt1


"GKW in GA" wrote:

I have a cell that is in date format. However it is in the wrong format. What
shows as 7/11/2001 really is supposed to be 2007/11/01. What shows as
7/12/2005 really should be 2007/12/05. Is there a formula I can use to
convert these. I dont care if the result is a date, text or numeric
formattted cell so long as 7/11/2001 reads as 2007/11/01 (11/01/2007) would
be acceptable as well.

Thanks