I received a worksheet from somebody else. It contains a column of dates. Format is m/d/yyyy ... e.g. Oct 25, 2007 = 10/25/2007. However, the cell format comes across as General. I need to change the format to some Date format but it won't "take". For example, when I changed the format to Date yyyy-mm-dd format, the cell format changed but the actual date did not. How can I overcome this hurdle? I need to do some date comparison formulas with this column.