ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel: save-as csv : delimiter set to semi-colon, not comma. Why? (https://www.excelbanter.com/excel-discussion-misc-queries/103516-excel-save-csv-delimiter-set-semi-colon-not-comma-why.html)

Luke Skywalker

Excel: save-as csv : delimiter set to semi-colon, not comma. Why?
 
When I use save-as csv, the delimiter used by Excel is semi-colon and not
comma. Why is this? Is there a setup that I can use to ensure comma as the
delimiter?

Dave Peterson

Excel: save-as csv : delimiter set to semi-colon, not comma. Why?
 
Excel picks up this delimited from the Windows Regional settings under the
control panel.



Luke Skywalker wrote:

When I use save-as csv, the delimiter used by Excel is semi-colon and not
comma. Why is this? Is there a setup that I can use to ensure comma as the
delimiter?


--

Dave Peterson


All times are GMT +1. The time now is 04:43 AM.

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