ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Changing CSV from ';' delimited to ',' (https://www.excelbanter.com/setting-up-configuration-excel/10755-changing-csv-%3B-delimited.html)

MiniBudha

Changing CSV from ';' delimited to ','
 
Is it possible to config excel to save my Excel file as csv using ',' as a
delimiter rather than a semicolon, Computer setup as French, and don't want
to have to reinstall.

Gord Dibben

Mini

See JE McGimpsey's site for methods.

http://www.mcgimpsey.com/excel/textfiles.html

BTW, you wouldn't have to reinstall. The delimiter could be changed in
Control PanelRegional and Language Options if running Windows.

That could be a hassle going forth and back if doing this often.


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 04:15:03 -0800, MiniBudha
wrote:

Is it possible to config excel to save my Excel file as csv using ',' as a
delimiter rather than a semicolon, Computer setup as French, and don't want
to have to reinstall.




All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com