Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When saving numerical data from Excel, the decimal separator is comma. Is that a problem?

April 26, 2017comma Data decimal Excel numerical problem Saving separator

0

Posted

When saving numerical data from Excel, the decimal separator is comma. Is that a problem?

1 Answer

0

Posted

Windows software is, by default, using local decimal separator, which is comma in Finland, Germany, France and Italy, and point in UK, USA and Japan. In-house software is mainly assuming decimal points. S1: Change the decimal separator from comma to dot in Windows or in Excel. S2: Use the latest versions of dft2html or dft2html to convert data files into XHTML table format and import those in Excel.