On Sun, 26 Mar 2006 14:44:41 -0800, noel
wrote:

date is now in mm/dd/yy (general format)

after switching cell format to dd/mm/yy (date format)

the same still


Your "date" is really TEXT. Formatting will not change the appearance of text.

Excel stores dates as serial numbers starting with 1 Jan 1900 (or 1904).

Let's gather more information to decide how to fix this.

How many dates are we talking about?
How did the date information get into the cell?
Will this be a repetitive task?
--ron