Community
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Support for European semicolon separated values

Support for European semicolon separated values

Hi,

I live in a country where the decimal separator is a comma, and when Excel opens or saves the CSV, it expects to be semicolon separated values.

For example, a PNEZD file will be like:

1;7600645,678;345276,8724;93,1213;CAP
2;7600645,525;345266,8736;93,0808;CAP
3;7600645,83;345286,8712;93,1619;CAP
4;7600646,135;345306,8689;93,2431;CAP
5;7600645,982;345296,8701;93,2025;CAP

The regional settings in Windows can be changed to have the period as decimal separator and commas as the delimiter. If you work often changing the regional number format, sometimes wrong formatted spreadsheets can be printed. Also if you have opened by mistake a Excel file that was formatted in European number system, the margins, headings and footings are wrongly converted from centimeters to inches, loosing the format.

It will be great that the point file format settings, has the option to select the decimal separator to be comma or period.

Greetings from Paraguay.

Claudio Bogado Pompa.

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea  

Answer Day

Rail Community


 

Autodesk Design & Make Report