I exported data to an xls file. When I open the file in Excel I am trying to format a column. I clicked on the column and changed it from General to Short Date. I need the date to be correct so it will sort correctly.
However, changing column to short date does not resolve it. Date 4/9/13 is between 4/30/13 and 5/10/13. When I try to change 4/9/13 to 4/09/13 it displays instead 41373.469583333.