wpdatatables not displaying prices

Hello,
First our apologies for the waiting time on this reply,
thank you for your patience.
–
In regards to this issue,
Can you tell us do you have any symbols inside the cells where your numeric data is,

for example a currency sign?

If so, this will not work with our Plugin for numeric Columns such as Floats or Integers.

The solution is, to remove any symbols and just leave pure numeric data in the cells of your source Google Sheet,

then you can make integer or Float Column from this in our connected Table.

 ( Just also double check if you have the same Number Format matched in the main plugin settings, and the decimal numbers)

After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.

Let me know if that helps.

Thank you.