Hi, Stan 

Thanks for reaching out to us

And thank you for trying to help a fellow user, Syed, that is always appreciated.

Exactly, the best first step is to check what is the number format coming from your source data,

and to match this Number Format in the main plugin settings/Number Format.

See if you change the current Number Format in the plugin - let us know if that solves the issue?

-

2. Also, as Syed correctly said, check how many decimals you have set in the main plugin settings,

as well as in the column settings in the table ( if you leave it to blank, it will pull this default decimal number, and zero decimals is only available for Formula columns) :

-

-

Let us know if that helps, but we also notice that this is a Manual Table, so it might be another issue.

3.  By default, all float columns for Manual Tables will initially be created in the database with 4 decimals.

Our developers are working to improve this behaviour,I can't say an ETA when it will be fixed,

but you follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

For the time being, we have two possible workaround solutions when we need a different number of decimal places:

1. If you want to get it working as Float Type, with proper numeric sorting, 

you can change the column setting directly in your database for the table.

Here is my example via PhPMyAdmin with screenshots for setting 6 decimal places. 

( My apology if you already know how to do this, i will share it just to be safe)

 First, we check what is the SQL table name, in the Editing tab:

-

Then we find the table in PhPMyAdmin and edit the column(s) we need to have 6 decimals :

-

Change the Length/Values for the Float Column from initial "16,4"  to the decimal number you need;

in this example "16,6"  - that will allow you to get 6 decimals without issues. ( But you can change it to any decimal number you need)

-

Once you go back to the table in our plugin, if you set it like that,

you will be able to have 6 decimals in this column for new rows.

-

2.  

Or you can set up a new column as String type, it will also work that way to display the value,

 but then you won't get proper numeric sorting.

Let me know if that helps and if you have any questions. Thank you