I am having issues with regards to the format of dates on a spreadsheet. The date is showing up on my sheet as 2010-09-27 despite the formatting being set to mm-dd-yy.

Actually, now that I look it doesn't matter what I change the format to, the date continually is displaying yyyy-mm-dd as shown. Even if I change the format to general or number, it is displaying 2010-09-27 and not the number associated with that date. Has anyone ever seen this where you can't change the format?

Thanks in advance for the help!