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.
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.
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