Martin Taylor wrote:
I got this far on my WinXP system and I had issues. In order to open this file correctly in Excel 2003 - i.e. using "|" as a separator - it is necessary to make a *global* change to the system, as follows:
Click the Windows Start menu. Click Control Panel. Open the Regional and Language Options dialog box. Click the Regional Options Tab. Click Customize. Type a new separator in the List separator box. Click OK twice.
This changes the list separator for *all* applications.
When I open with OOo, by contrast (1.9m100), it asks me what the separator character is, then loads the file correctly into multiple columns.
That's interesting. I'm using MSO 2000 and the import process was almost identical to OOo. Even the dialogs looked remarkably similar. Sounds like a regression to me. I wonder what the hell inspired them to make that particular change?
I could understand (and appreciate) an application level option that would set it to a particular character as the default. The way it is with either MSO 2000 or OOo, you have to specify each time.
Rod
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
