Title: In Float column
Last modified: January 2, 2023

---

# In Float column

 *  Resolved [jonomteam](https://wordpress.org/support/users/jonomteam/)
 * (@jonomteam)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/i-float-column/)
 * 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 3 years, 4 months ago by [jonomteam](https://wordpress.org/support/users/jonomteam/).

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/i-float-column/#post-16349134)
 * 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](https://wordpress.org/support/users/jonomteam/)
 * (@jonomteam)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/i-float-column/#post-16349753)
 * This is my data 👇
 * [https://jonomdigital.xyz/help](https://jonomdigital.xyz/help)
 * i want this kindly of data
 * **[https://ibb.co/xzK15xm](https://ibb.co/xzK15xm)**
 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/i-float-column/#post-16381458)
 * 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](https://watch.screencastify.com/v/xOOhkb1mfy74Un5T3AMz)
   Let me know if that helps, i believe it should solve the issue.
 * Thank you
 *  Thread Starter [jonomteam](https://wordpress.org/support/users/jonomteam/)
 * (@jonomteam)
 * [2 years, 12 months ago](https://wordpress.org/support/topic/i-float-column/#post-16783866)
 * 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.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [jonomteam](https://wordpress.org/support/users/jonomteam/)
 * Last activity: [2 years, 12 months ago](https://wordpress.org/support/topic/i-float-column/#post-16783866)
 * Status: resolved