I regularly download a .csv file which I open in Excel and then save as 97-2004 workbook (.xls). Contained in this .csv file is a column with dates which are formatted as short dates. I can't seem to find a way to convert these to long dates other than changing the format and then manually retyping each date, perhaps there is one more step I'm unaware of that will accomplish this. Can someone help me out? Would very much appreciate it.