6 Replies Latest reply: Jan 6, 2017 9:00 AM by Zhihong He RSS

    dimension number format not working in excel

    Zhihong He

      Hi, all,

      I use nprining 16.3 and QV 11.20 SR12.

      I am export a pivot table in an nprinting excel template. The dimension Unit with number format '#,##0.00' is exported as General (default number in excel).

      My desired output:

      CurUnitNum
      EUR1.80626
      EUR1.8018
      USD1.808
      EUR0.45160

      The actual output:

      CurUnitNum
      EUR1.8626
      EUR1.818
      USD1.88
      EUR0.45160

       

      I modified the Document property ->Number for Unit field, and it does not work. The Unit is all number with 2 decimals, no string.

      This can also be test by just export the table to excel in QV, get the same result with "General" format.

      May I know how can I get my required number format?

       

      Thanks

      Zhihong