Greetings,
I download historical stock prices from yahoo! The format is csv. When I get them I have to modify them slightly, here's what I do:
Open the file, insert a top row for column headings. Add the headings. Select the first column, format the column as date, 15-Mar-95, then I save...