2016年9月26日星期一

I have been using Excel for years and KNOW how to format a date. I have a brand new worksheet. The date format in Control Panel is the way I want it (mm/dd/yy). I have formatted the date column in my spreadsheet to short date format (I've reset it to every imaginable combination to see if one works). I've used the format painter from a "good" cell to try to fix the bad cell. Nothing works. I enter every date in exactly the same way, yet some will pick up the date format and others will go to text format. Nothing I can do will change it. I've even tried using Microsoft's suggestion of converting a text-formatted date using @datevalue(), but all I get is a #value error. I haven't been able to find anything on this particular error - only how to select a date format. As an example, I entered these values:9/7/122/28/1310/29/1211/16/12