yes, I agree, they were entered incorrectly in the first place. THe problem
is they were not keyed in, they were loaded from another application where
they were formatted incorrectly before being imported to Excel. Problem is
there are several thousand of them.

That is why I was looking for a formula.

"Bob Bridges" wrote:

Yeah, I'm with Rick; the problem here isn't that the format is misleading but
(judging by your description) that the spreadsheet misunderstood the dates as
they were entered. To put it another way, Excel isn't displaying the dates
in a way that looks confusing to you; it really thinks that that first date
is supposed to be July 11, 2001, and the second July 12, 2005. Re-enter
those dates correctly and you'll have no difficulty getting them to display
in whatever format you choose.

--- "Rick Rothstein (MVP - VB)" wrote:
What is it that you entered into this cell in the first place?

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