Re: Unicode in Excel 2000

From: Bob Leschorn (blesch@cix.compulink.co.uk)
Date: Tue Oct 03 2000 - 08:17:12 EDT


In-Reply-To: <200010022031.MAA21700@unicode.org>
In article <200010022031.MAA21700@unicode.org>, peck@spss.com (Peck, Jon)
wrote:

> A little off topic...
>
> Does anyone know whether Excel can read a Unicode CSV-format file?
> Although
> such a file opens in Word 2000 fine, Excel seems terminally confused,
> whether fed utf-16 or utf-8. The only documentation I could find seems
> to
> consider Unicode files and csv files as separate categories.
>
> TIA
>
> Kim Peck
> SPSS Inc

Actually, I found that if the file is named *.CSV, Excel gets confused. If
it is named *.TXT, it imports OK. Bizarre.

=========================================================================
Bob Leschhorn blesch@cix.compulink.co.uk
Ark Software blesch@arksoft.com
Gerrards Cross, Bucks Tel: +44 (0)1753 887431
United Kingdom Fax: +44 (0)1753 884693
=========================================================================



This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:14 EDT