• hey I have problem for example user earning Money is 2.59 but In wpdatatable showing 259,00 I want this format 2.59 how to do that .

    • 0.03
    • 0.16

    show content

    ? 3,00

    ? 16,00

    We don’t want this content to show. Kindly help me.

    • This topic was modified 2 years, 2 months ago by jonomteam.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    Hello,

    can you first please check in your main plugin settings/Decimal places,

    you should have “2” set there;

    Then, i also think that there is probably some kind of formatting on the cells in your source file that you are linking with this table,
    so what you can do is;
    select all the data you need from your original file source and copy it ( i guess it is probably CSV, Excel or Spreadsheet, right?),
    and then paste this as “unformatted data” ( only values without any formatting) into a new Spreadsheet, CSV or Excel file;
    save the new file;
    then try to make a new table from that “unformatted” sheet, and let me know if then the numbers render as you need them?
    Thank you

    Thread Starter jonomteam

    (@jonomteam)

    This is my data ??

    https://jonomdigital.xyz/help

    i want this kindly of data

    https://ibb.co/xzK15xm

    Plugin Author wpDataTables

    (@wpdatatables)

    Hello,
    i have exported an Excel from your table, and i can see there is some kind of formatting on the numeric data.

    What i did now is, i have unformatted/cleared formatting on the column Royalty (INR) ,
    and i typed in some random numbers, with formatting as you requested;
    then i make sure in my main plugin settings to set the correct number format and 2 decimals,
    and when i link this Excel, it loads the numbers as you need them.
    Please check my Video here to see what i did. https://watch.screencastify.com/v/xOOhkb1mfy74Un5T3AMz
    Let me know if that helps, i believe it should solve the issue.

    Thank you

    Thread Starter jonomteam

    (@jonomteam)

    i want your video sir Again

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘In Float column’ is closed to new replies.