Announcement

Collapse
No announcement yet.

Nitro Query excel export number formatting

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Nitro Query excel export number formatting

    Hi,
    In the latest version of Valence the Nitro Query now exports to excel with different style for numeric columns with 2 decimal positions. It used to have 2 decimals after the point but now numeric columns with 2 decimal places look as attached (see Value column). How do we revert to the previous format for munerics with 2 decimal place (i.e. dollar amounts)?
    Excelstyle.png

  • #2
    You can select "Legacy Excel" on the widget download section from within configure.

    What formatting option do you have selected for the column or if you have custom formatting can you supply it?

    legacyExcel.png

    Thanks

    Comment


    • #3
      We found the issue where it was supplying Excel with an incorrect number format and this will be fixed in our next updated. Thanks for letting us know.

      Comment

      Working...
      X