On 6/1/07, H.Merijn Brand <[email protected]> wrote:
Now try loading this in Excel:
20070512,20071205,05-12-2007,12-05-2007,12/05/2007,05/12/2007,"20070512",...
etc etc, preferably under a locale that does not use the braindead american
MMDDYYYY sequence. Try opening the csv in three ways: 1. double-click in
internet-exploder, 2. open M$-Excel and open the csv from the file menu,
and 3. open M$-Excel and go to Data-Import-FromFile and choose the CSV file.
Compare the results.
Ah, yes.
For extra-special, open the file in a text editor, copy the contents
to the clipboard, and paste into Excel. Then click the little
drop-down thingy in a corner of the selection and choose "use text
import wizard", or not, for two more methods.
I had fun with some data several times as well, where I had to try
several methods to get what I wanted.
Cheers,
--
Philip Newton <[email protected]>
