Microsoft KB Archive/288839

= XL: Exported Comma Separated File Ignores Regional Settings =

Article ID: 288839

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q288839



SYMPTOMS
When you use a Microsoft Visual Basic for Applications (VBA) macro to save a Comma-separated values (.csv) file, Excel ignores the Microsoft Windows regional setting for the List separator character.



CAUSE
Excel uses the default U.S. regional settings when running a macro. This behavior ensures that the result of running macro code is consistent regardless of the computer's regional settings.

Because the default separator character in English (U.S.) is a comma, Excel uses a comma as the separator.



WORKAROUND
If you need .csv files to be separated according to the regional settings, click Save As on the File menu to save the file manually.

Additional query words: XL2000 prb XL2002 XL97

Keywords: kbprb KB288839

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.