topic Re: Decimal point to komma for exporting to excel in Mathcad https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378308#M148436 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.ptc.com/legacyfs/online/98184_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sat, 13 Feb 2016 05:50:04 GMT ValeryOchkov 2016-02-13T05:50:04Z Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378302#M148430 Is there a Possibility?I need Komma in Excel and need to adjust in MathcadThx <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span> Thu, 03 May 2018 14:41:45 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378302#M148430 sm�ller-2 2018-05-03T14:41:45Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378303#M148431 <HTML><HEAD></HEAD><BODY><P>after exporting to excel there is standing as letter saved number ?!!!!</P></BODY></HTML> Fri, 12 Feb 2016 18:38:45 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378303#M148431 sm�ller-2 2016-02-12T18:38:45Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378304#M148432 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD>Is there a Possibility? <P>I need Komma in Excel and need to adjust in Mathcad</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>No, unfortunately that's not possible.</P></BODY></HTML> Sat, 13 Feb 2016 02:34:03 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378304#M148432 RichardJ 2016-02-13T02:34:03Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378305#M148433 <HTML><HEAD></HEAD><BODY><P>I may be missing the point, but I use a German Windows, too, and the the setting in Windows of course is using the comma as decimal separator.</P><P>I experience no problems using READEXCEL and WRITEEXCEL. Numbers with commas are correctly read in in Mathcad and use the decimal point there. When exporting floating point numbers from Mathcad to Excel I get correctly formatted numbers (with decimal comma) in Excel.</P><P></P><P>The only problems I am aware of are when using scripted components, because VBS will use the windows settings and therefore sends numbers with comma instead of decimal point to Mathcad, which Mathcad does not understand. So scripts may need some rework to compensate for that.</P><P></P><P>R</P></BODY></HTML> Sat, 13 Feb 2016 03:10:31 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378305#M148433 Werner_E 2016-02-13T03:10:31Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378306#M148434 <HTML><HEAD></HEAD><BODY><P>Interesting. However, I remember you saying that you use Mathcad in English. If you switch to German in Mathcad does the export still work OK?</P></BODY></HTML> Sat, 13 Feb 2016 03:15:31 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378306#M148434 RichardJ 2016-02-13T03:15:31Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378307#M148435 <HTML><HEAD></HEAD><BODY><P>Thats correct. I am using the German version of Mathcad but with menu and math language switched to English.</P><P></P><P>I just gave it a try and switched to German. Quit and restart and again no problems with Excel ex- and import of floating point numbers.</P><P>Not sure which kind of problems Stefan is experiencing.</P><P></P><P>From what he wrote it looks like numbers exported from Mathcad are formatted as text in Excel.</P></BODY></HTML> Sat, 13 Feb 2016 04:15:07 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378307#M148435 Werner_E 2016-02-13T04:15:07Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378308#M148436 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.ptc.com/legacyfs/online/98184_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sat, 13 Feb 2016 05:50:04 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378308#M148436 ValeryOchkov 2016-02-13T05:50:04Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378309#M148437 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P></P><P>routine is working but i dont get rif of the problem with the komma ;-(</P><P></P><P>Every time after opening excel it says the data is broken. And every number with komma is green. As letter saved number.</P><P></P><P>Hopefully u guys can provide me with a fix of that <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>The problem is that i have hundreds of different loadcases and i cannot change very each output what mathcad does in excel manually.....</P><P></P><P>regards Stefan</P><P></P><P>A and i have MAthcad 15 <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P></BODY></HTML> Sat, 13 Feb 2016 06:29:51 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378309#M148437 sm�ller-2 2016-02-13T06:29:51Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378310#M148438 <HTML><HEAD></HEAD><BODY><P>yes i attached the relevant datas</P></BODY></HTML> Sat, 13 Feb 2016 06:31:52 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378310#M148438 sm�ller-2 2016-02-13T06:31:52Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378311#M148439 <HTML><HEAD></HEAD><BODY><P>Try to change the settings in Excel (<STRONG>MS Excel 2010</STRONG> is on screenshot below): "<STRONG>Excel options</STRONG>" --&gt; "<STRONG>Additionally</STRONG>" --&gt; "<STRONG>Options changes</STRONG>" --&gt; "<STRONG>Use system separators</STRONG>".</P><P></P><P><IMG __jive_id="98293" alt="Pic_1.png" class="jive-image image-1" src="https://community.ptc.com/legacyfs/online/98293_Pic_1.png" style="height: 437px; width: 620px;" /></P></BODY></HTML> Tue, 16 Feb 2016 09:15:04 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378311#M148439 VladimirN 2016-02-16T09:15:04Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378312#M148440 <HTML><HEAD></HEAD><BODY><P>I see the problem when I open your Excel File, but after reading and (re)writing it using your Mathcad file, all is OK again.</P><P>I attach the file after it was reworked by Mathcad.</P></BODY></HTML> Tue, 16 Feb 2016 13:28:34 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378312#M148440 Werner_E 2016-02-16T13:28:34Z Re: Decimal point to komma for exporting to excel https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378313#M148441 <HTML><HEAD></HEAD><BODY><P>not working <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>i have office 2016 plus</P><P>every time the same problem grml </P></BODY></HTML> Tue, 16 Feb 2016 16:02:45 GMT https://www.ptcusercommunity.com/t5/Mathcad/Decimal-point-to-komma-for-exporting-to-excel/m-p/378313#M148441 sm�ller-2 2016-02-16T16:02:45Z