Hi, Has anyone else had a problem with the date format in excel 2011? I have a budgeting/expense tracking spreadsheet that I have been using for years in Office for macs 2003. I generally sort this spreadsheet on the date column. However, when I upgraded to Lion (which forced an upgrade to Office 2011) the date column is always treated as text (the sort is alpha-numeric vs m/d/y). I have the most up-to-date OS and office software and am running this on a 2010 MBR and a 2 week old MB Air. I have 6 years of data (thousands of lines) in this spreadsheet so creating a new spreadsheet is not an option I want to explore. I've tried inserting a column and setting a new date format for it has not worked. As soon as I type Dec 18, 2011 it stays as text. Any thoughts?