Excel Format [RESOLVED]

I have an excel worksheet that is possible going crazy, it is displaying a diffrent date format then the cell is set to, but only for specific records not the entire thing, the information is added by the same person from the same computer. Ne ideas?


btw Excel 2000 on xp sp2 compys date format is set to mm/dd/yyyy

nvm figured it out the user was entering it in dd/mm/yy and the compy is formated to mm/dd/yy because the records were like 07/10/06 compy didnt know what to think lol