As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2888749
excel decimal conversion
Closed

Comments

  • Gage Robinson started the conversation

    New to this setup, so far things are merging over from excel really nice. My only hick up is we do work from the smaller number values such as 0.100, when I originally loaded this up the preview page was 100% correct. When I went to finalize it and its asks you, do you want to view as standard or excel-like, that next page is where it converts all the data to standard decimal places and even if you go to edit the decimal points, it only makes the value bigger, not smaller. 

    So I would want 0.100 and this gives me 1000, and editing to decimal at 4 places gets me 100,000 ...

    I'm sure its an easy fix but I'm missing it, and I have hundreds of line items like this. 

  • [deleted] replied

    Hi Gage

    Thank you for reaching out to us.

    Can you please tell us if the number format in the source file matches the number format set in wpDataTables - Settings - Main settings

    1791098002.png