Title: Float Numbers with Commas
Last modified: July 31, 2020

---

# Float Numbers with Commas

 *  Resolved [GM](https://wordpress.org/support/users/gmchoops/)
 * (@gmchoops)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/float-numbers-with-commas/)
 * Good evening. I’ve been using your widget or plugin for the past month or two,
   and like it a lot. The only real problem I have been having up to this point 
   is when I import an Excel or CSV file with float numbers. WPDataTables doesn’t
   seem to like the decimal point, and converts it to a comma. As a result, I have
   to change the data type to string so that it looks like how it is in Excel/CSV.
   Is there a way I can get around that using the basic version, or do I have to
   pay to get the premium version.

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/float-numbers-with-commas/#post-13216371)
 * Hi there
 * Sorry for the late response.
 * This works the same in both Lite and the full version of the plugin. You need
   to make sure your floats have the same format in your CSV file, and in wpDataTables.
 * You can change the number format in wpDataTables settings, so the decimal comma
   is changed to a dot.
 * Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘Float Numbers with Commas’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/float-numbers-with-commas/#post-13216371)
 * Status: resolved