I am uploading a spreadsheet in order to make a table. The third column should be numbers with two decimal points. For example "25.49" I have formatted them in the excel spreadsheet properly(attached in csv format). Additionally, I have the setting in WP Datatables for the column as "Float" and 2 decimals, just like the spreadsheet. Screenshot attached. However it still doesn't work. "25.49" will be displayed as "2549,00". This is clearly a malfunction. Please advise how I can fix the formatting of the spreadsheet to make decimal numbers display properly. Thanks!
The number format in wpDataTables is set to 15.000,00 where a comma is a decimal separator, while your CSV file's format is 15,000.00 where a dot is a decimal separator.
Change the format in wpDataTables settings, and try again.
I am uploading a spreadsheet in order to make a table. The third column should be numbers with two decimal points. For example "25.49" I have formatted them in the excel spreadsheet properly(attached in csv format). Additionally, I have the setting in WP Datatables for the column as "Float" and 2 decimals, just like the spreadsheet. Screenshot attached. However it still doesn't work. "25.49" will be displayed as "2549,00". This is clearly a malfunction. Please advise how I can fix the formatting of the spreadsheet to make decimal numbers display properly. Thanks!
Hello Jacob.
The number format in wpDataTables is set to 15.000,00 where a comma is a decimal separator, while your CSV file's format is 15,000.00 where a dot is a decimal separator.
Change the format in wpDataTables settings, and try again.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables