8 Replies Latest reply: Apr 1, 2016 9:54 AM by Shannon Marshall RSS

    Wrong value format when copying values to Excel

    Suvi Ahlstedt

      Hi all,

      Can someone help me with copying values to Excel? I have customer who exports values to Excel but value format is incorrect in Excel. For example if value is 17,5, Excel interprets value as date and shows value as May 17th. QV application has decimal separator comma as well as Excel does. I can not repeat this problem, if I export values to Excel, all values are shown correct. Both customer and I have Office2013, only difference is that my Office is in English and customers is in Finnish. We have checked Excel options that desimal separator is comma. What else should I check and change that all values will be correct? I have tested in QV to change number format to number or integer but it didn´t help. That is weird because if I export values to Excel from customers application, everything is fine..

      Best,

      Suvi