View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Al
 
Posts: n/a
Default CSV formatted files open odly in Excel 2000

This can also be cause by a damaged Registry Office XP Excel Options key
If you know about the Registry, it is the following key which you can delete
to fix the problem - I recommend you Export the key first for backup

HKEY_CURRENT_USER
Software
Microsoft
Office
XX ( this is the version of Office 10.0=XP, 11=2003)
Excel
Options (Export then delete this key)

The CSV files should work after that.

"rbecerra" wrote:


Hi,
as far as I remember, I was experiencing the same problem. And the
cause was the regional settings of the computers (digit grouping char
and decimal char).

For a CSV to be openned successfully in Excel, your digit group
character should be ",".

Hope this could help


--
rbecerra
------------------------------------------------------------------------
rbecerra's Profile: http://www.excelforum.com/member.php...o&userid=27043
View this thread: http://www.excelforum.com/showthread...hreadid=399367