|re: "But i dont wan to deal wid that"|
Let's make sure we are on the same page. I am trying to help you without being able to see your spreadhseet or see what it happening when you try to change the format. By asking you to try the MONTH function, I was simply trying to determine if Excel was recognizing the contents of the cells as dates.
In your OP your said: "I already tried by using >format cell > number tab > date , but it is not working."
I then asked What do you mean "it's not working"?
Again, since I can't see your spreadsheet from where I am sitting, I don't know what not working means. So I'll ask again: What does "not working" mean?
What happens when you try to change the date format?
Have you tried entering a date such as December 12, 2011 (something with a 2 digit month) and setting the format to mm/dd/yyyy?
Date formats in Excel can be finicky especially with dates like 02/05/2011 where both 05 and 02 could mean either the Month or the Day. Since I can't duplicate your "problem" all that I can do is ask questions and suggest things to try as a means to narrow down the possible cause.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.