I ran a report from MSDSonline to get an inventory of my locations products. The report has a date format of 1996-03-01. I want to change it to 03/01/1996, (assuming that the 03 is March). Nothing I have tried will change the date format in the column. I've ensured that the cells are not locked. I've "cleared" any formatting on the entire spreadsheet. I've tried to copy/paste values. I'm at a loss. I did a little research on Microsoft's site, and found people posting about the same situation, but could not find a resolution. Can anyone help?